I have a large spreadsheet with 100,000 rows and in one column we have variations of numbers and text numbers. We formatted the whole column as text to enable vlookup to another worksheet for a column of similarly formatted combinations, formatted as text. The primary column needs every cell of text activated. We use F2 then enter on every cell. This is tedious and we need another way to activate all these cells to acknowledge the text, so the Vlookup will work properly.