I have a spreadsheet with a vlookup and the Lookup is a numeric value but it will not work unless the number is set to text. I have reformatted the cells to text but nothing happens until I either double click the cell or retype the number, is there an easier way to covert the numeric values to TEXT. I have 6000 lines and I don't want to double click (or add a ') to each line
I've managed to get this converted by adding a column of quotes (') and concatenating the quotes(') and the orginal number into a general cell and then use paste special to paste the value back over the orginal cell... long winded but better than double clicking a lot cells... I'll download addon anyway ans have a look .