Number to text with leading zero

[Guest]

Hi,

I need to change a to digit format cell to text.

the thing is the numbers are like this:
First Digit 0, next a 1-9 Number ej. 01,02,03...09

However, when i convert to text, the leading zero disappears.

How can I avoid that.

thanks

 

[Frank Kabel]

Hi
try
=TEXT(A1,"00")

 

[Guest]

thanks Frank!

Hi
try
=TEXT(A1,"00")