if 51126 is ib a1 in B1 type
="0"&A1
copy this formula down
Natalie wrote in message
...
Does anyone know how to add characters to the beginning of numbers -
I have a list of numbers
51126
54889
53665
and I want
051126
054889
053665
I can't use the format cells, as I need the numbers to be text??
Thanks
|