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
Blog by abdza. Open Source, Computers, Gadgets, Life, Love and everything in between.
Friday, November 25, 2011
Changing to text in Excel
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:
Subscribe to:
Post Comments (Atom)
Is Blogging No Longer a Thing?
As I embark on my new journey to learn the Rust programming language, I find myself pondering—where have all the blogs gone? In search of pr...
-
My blogs' name is High-Tech Rojak but I don't recall ever talking about food. So here's a first. Just recently I got some free t...
-
Yesterday went to Low Yat to buy my cousin a sub RM 1500 notebook. Of course with that kind of price tag it would have to be a netbook jelah...
-
Finally there is a need for me to actually install the latest version of OpenOffice.org. To do it first install the ppa by adding the follo...
1 comment:
hahahahahahahahhaha vb hahahahahahahahaha
Post a Comment