If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CSV File - Leading Zeros
I am opening a common delimted file in Excel and formating 2 fields as "text"
to retain leading zeros. They appear correctly in Excel. I then need to save as a "csv" file and retain the leading zeros. How can I do this? The zero's always drop off in the csv file when retrieved again in excel. TIA |
#2
|
|||
|
|||
hi,
do you need to save the csv every time, if you save I agree it will remove the zeros. There is no perfect solution to this but if your file format is standard, you may consider preparing a excel template with the repeate, concencanate and left and right formula. This will fill a particular cell with appropriate number of zeros base on the number of digits you have in the cell. thanks, Hitesh "Floridagal" wrote: I am opening a common delimted file in Excel and formating 2 fields as "text" to retain leading zeros. They appear correctly in Excel. I then need to save as a "csv" file and retain the leading zeros. How can I do this? The zero's always drop off in the csv file when retrieved again in excel. TIA |
#3
|
|||
|
|||
Rename your .csv file to .txt and when you import it, you can tell excel to
treat the field as text. Floridagal wrote: I am opening a common delimted file in Excel and formating 2 fields as "text" to retain leading zeros. They appear correctly in Excel. I then need to save as a "csv" file and retain the leading zeros. How can I do this? The zero's always drop off in the csv file when retrieved again in excel. TIA -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Remove Split or Trim Leading Zero's | Scott | General Discussion | 1 | May 10th, 2005 05:55 PM |
Crystal Reports Export to Excel - Retaining Leading Zeros | CR-Tech | General Discussion | 1 | November 1st, 2004 06:15 PM |
Office 2003 uninstall/reinstall problems | Jerryn3 | Setup, Installing & Configuration | 2 | August 2nd, 2004 03:39 PM |
Application must be installed to run Error | Keith | Setup, Installing & Configuration | 1 | June 29th, 2004 03:02 AM |
Unsafe Attachments | Ron | Installation & Setup | 2 | June 9th, 2004 01:55 AM |