Loosing Leading zeros in CSV file

G

Guest

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
 
N

Niek Otten

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

Arien

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

regards,
Arien
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open csv file with Leading Zeros 1
How to stop Excel from automatically truncating leading zeros 2
Importing to Excel from csv AND keep leading zeros 2
CSV File - Leading Zeros 2
leading zeros fall off in csv format. 4
Leading zeros won't convert to csv file in Excel ver 6 SP2 2
Leading zeros in CSV and Excel 97 1
Keeping leading zeros in imported data (one digit month as 05) 2

Top