Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel drops my lead zeros: need 0051 not 51 | Excel Discussion (Misc queries) | |||
20 digit wont stop ending in zeros | Excel Discussion (Misc queries) | |||
EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER | Excel Discussion (Misc queries) | |||
line graph drops when zeros | Charts and Charting in Excel | |||
csv file drops zeros at beginning of a set of Numbers | Excel Discussion (Misc queries) |