I find that I have to do this once in a while and every time I'll have to look it up again. Basically the problem is that someone sent an excel file which the column need to be a string but the data is numerical, so without adding the tick in front of the number, excel interprets it as number. Here's the small script to add the tick: For i = 2 to 196 Range("C" & i).Select ActiveCell.FormulaR1C1 = "'" & ActiveCell.Value Next Now I won't have to google all those mysterious command again the next time it happens.. p/s: don't laugh at me struggling with vb you insensitive clod.. :P
Blog by abdza. Open Source, Computers, Gadgets, Life, Love and everything in between.