 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006CSV Format
Hi Folks - I have an .xls file with a zip code column entered as text. I need to send the file to the feds as a csv file. When I Save As the xls file to a csv file, I lose the leading zeros in the zip code. Any ideas? Michael Have you tried formatting the entire column as text? I don't know if that will work, but give it a shot. > Hi Folks - I have an .xls file with a zip code column entered as text. I > need to send the file to the feds as a csv file. When I Save As the xls file > to a csv file, I lose the leading zeros in the zip code. Any ideas? > > Michael Also -- after you've created the .csv file, open it in Notepad *not* Excel. See if the leading zeros are there. > Hi Folks - I have an .xls file with a zip code column entered as text. I > need to send the file to the feds as a csv file. When I Save As the xls file > to a csv file, I lose the leading zeros in the zip code. Any ideas? > > Michael You need to save it as txt rather than csv. If you open the txt file, you will be prompted on how to handle the columns on a column by column basis. For the zipcode column, open as text. With the CSV format, you have not truly lost the leading 0's, it is just when you reopen it in Excel as the csv, the automatic assumption is General and that drops the leading 0's > Hi Folks - I have an .xls file with a zip code column entered as text. I > need to send the file to the feds as a csv file. When I Save As the xls > file to a csv file, I lose the leading zeros in the zip code. Any ideas? > > Michael Hi Folks - Here's a follow-up ..... it turns out that Excel WAS saving the leading zero during the conversion from .xls to .csv. However, when Excel opened the .csv file, it converted the text field to a number field thus dropping the leading zero. Opening the .csv file with Notepad confirmed the proper .csv conversion. Thaks for everyone's help. Michael > You need to save it as txt rather than csv. If you open the txt file, you > will be prompted on how to handle the columns on a column by column basis. [quoted text clipped - 9 lines] >> >> Michael |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.