E Excel 2007 - CSV format Jun 23, 2009 #1 I'm saving an excel file into a csv format and its dropping the zeros at the end of the numbers.
G Gary''s Student Jun 23, 2009 #2 Use the Import Wizard: Data > Get external data > from text file and specify your .csv You will be able to control the formatting.
Use the Import Wizard: Data > Get external data > from text file and specify your .csv You will be able to control the formatting.
D Dave Peterson Jun 23, 2009 #3 You can also rename the .csv file to .txt and use file|open. You'll be prompted to give the type of field for each column. If you choose text, the leading 0's will be kept. If you want to keep the value as a real number, you'll can keep the .csv (or ..txt) and give the column a nice number format: format|cells|number tab|Custom category 00000 (for 5 digits)
You can also rename the .csv file to .txt and use file|open. You'll be prompted to give the type of field for each column. If you choose text, the leading 0's will be kept. If you want to keep the value as a real number, you'll can keep the .csv (or ..txt) and give the column a nice number format: format|cells|number tab|Custom category 00000 (for 5 digits)
