I am formatting a column of number/letters to be stored as text. A formula relies on a vlookup with this column being used as the first criteria. It should work fine however I must go into each cell in the column, hit F2, then hit enter for the formula to identify it is stored as text. Is there an easier way to do this for the entire column since it is thousands of cells?
Solved by T. C. in 14 mins