View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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