Hi
With number p.e. in A1:
=TEXT(A1,"00000")
--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets
"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
|