Number to text with leading zero
 

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

Number to text with leading zero
 

Hi
try
=TEXT(A1,"00")

--
Regards
Frank Kabel
Frankfurt, Germany


German wrote:
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

Number to text with leading zero
 

thanks Frank!

"Frank Kabel" wrote:

Hi
try
=TEXT(A1,"00")

--
Regards
Frank Kabel
Frankfurt, Germany


German wrote:
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