Hello

How do i stop a CSV file loosing leading zeros.

when the file is in excel format it is exactly how i want it, but to import
it into another program i need to save it as a csv file and it is then that i
loose the leading zeros

has any body got any ideas

--
Cheers

Instead of exporting a number, export "=TEXT(YourNumber,"00000000")" or as
many "0"s as you need

--
Kind regards,

Niek Otten

"Joe" wrote in message
...
Hello

How do i stop a CSV file loosing leading zeros.

when the file is in excel format it is exactly how i want it, but to
import
it into another program i need to save it as a csv file and it is then
that i
loose the leading zeros

has any body got any ideas

--
Cheers

You could also Format the cell (CTRL+1) | Number | Custom and type
000000000 in stead of Standard.
That would do the job.

regards,
Arien


--
Arien
------------------------------------------------------------------------
Arien's Profile: http://www.excelforum.com/member.php...fo&userid=1892
View this thread: http://www.excelforum.com/showthread...hreadid=497506