Supressing a leading zero>

Mike · Jan 21, 2004

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 · Jan 21, 2004

Hi Mike,

format the cell with the custom format "000000"

HTH
Frank

Mike · Jan 21, 2004

Frank Kabel said:
Hi Mike,

format the cell with the custom format "000000"

HTH
Frank

Thanks Frank, that did the trick..