number to text macro in EXCEL 2013
Posted on 2014-04-30
I need some help in properly write a macro in excel, I used to be able to do this in LOTUS123 but I can't figure it out in EXCEL.
I have 4400 lines of nun sequential numbers that I need to be text. I tried just formatting the column as text but that did not hold the "0" in the last place on the number like I need, so I need to write a macro that will put the apostrophe in front of the number.
when I try to record a macro and the run it, it takes the data (number) from the cell where the macro was written and copies it down with the apostrophe.
So obviously that is no good.
how do I fix this.