software

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 quot;=TEXT(YourNumber,quot;00000000quot;)quot; or as
many quot;0quot;s as you need

--
Kind regards,

Niek Otten

quot;Joequot; gt; wrote in message
...
gt; Hello
gt;
gt; How do i stop a CSV file loosing leading zeros.
gt;
gt; when the file is in excel format it is exactly how i want it, but to
gt; import
gt; it into another program i need to save it as a csv file and it is then
gt; that i
gt; loose the leading zeros
gt;
gt; has any body got any ideas
gt;
gt; --
gt; 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: www.excelforum.com/member.php...foamp;userid=1892
View this thread: www.excelforum.com/showthread...hreadid=497506