|Posted by:||James8309 (jaedong12…@gmail.com)|
|Date:||Sun, 6 Jul 2008|
In Column A:A I have phone numbers in each cell and they are in this
format [Special -> Dutch -> Telefoonnummer]
If I make it into General '0' infront will disappear.
Q: How do I change those numbers into 'Number stored in Text' (Those
numbers where little green box thingy appear on the top left of the
cell)? If I just change the format, it becomes 290099009 again and I
have to type '0' manually then it becomes 'Number stored as Text'.
Since I have like 40,000 numbers I don't think I can do it by
thank you for your help.