Supressing a leading zero>

[Mike]

Hi,

I have a CSV file which is generates a line similar to this

a,b,c,001234,10.00

When this is opened in Excel 2002 (windows) the 001234 is displayed as 1234.
How do I force it to display as 001234?

Thanks

Mike

 

[Frank Kabel]

Hi Mike,

format the cell with the custom format "000000"

HTH
Frank

 

[Mike]

Hi Mike,

format the cell with the custom format "000000"

HTH
Frank

Thanks Frank, that did the trick..