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 format drops ending zeros
I'm saving an excel file into a csv format and its dropping the zeros at the
end of the numbers. |
#2
|
|||
|
|||
csv format drops ending zeros
Use the Import Wizard:
Data Get external data from text file and specify your .csv You will be able to control the formatting. -- Gary''s Student - gsnu200858 "Excel 2007 - CSV format" wrote: I'm saving an excel file into a csv format and its dropping the zeros at the end of the numbers. |
#3
|
|||
|
|||
csv format drops ending zeros
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) Excel 2007 - CSV format wrote: I'm saving an excel file into a csv format and its dropping the zeros at the end of the numbers. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|