View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
German[_5_] German[_5_] is offline
external usenet poster
 
Posts: 2
Default 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