rgb192
asked on
want leading 0's in a csv file not xls
want all the fields in a column to be 9 digits
some numbers are
67
want
00000000000067
tried column change in microsoft excel 2007
but will not save because I need to convert to .csv
some numbers are
67
want
00000000000067
tried column change in microsoft excel 2007
but will not save because I need to convert to .csv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, but when I started to type my answer there was no mention of "csv" (file) in your question text.
ASKER
correct answer before I edited
thank you
thank you
In order to maintain leading zero(e)s within Comma Separated Value [CSV] format files, the respective columns (fields) will be required to be enclosed within quotes.
For example...
---
"00000000000067", "second column row 1"
"00000000000123", "second column row 2"
"00000000004567", "second column row 3"
---
If you wish to create CSV files with numeric fields in this manner, then you will need a bespoke file creation routine such as this:
[ http://www.mcgimpsey.com/excel/textfiles.html#fixedfield ]
For example...
---
"00000000000067", "second column row 1"
"00000000000123", "second column row 2"
"00000000004567", "second column row 3"
---
If you wish to create CSV files with numeric fields in this manner, then you will need a bespoke file creation routine such as this:
[ http://www.mcgimpsey.com/excel/textfiles.html#fixedfield ]
ASKER