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 NextNow 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
Comments