| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data truncates when converting .csv to .xls
I receive every day an e-mail with a file with data in .csv format.
When opening this file as a .xls, a specific field with a 20 digit value, gets truncated and last 5 digits appear as Cero. (of course they were not Cero in the original .csv file) in summary: "23848730987391234598" is converted to -- "23848730987391200000" can someone help? than you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help...Need to modify data within a column in a .csv file | Excel Worksheet Functions | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| my data truncates when ported from access to excel | Excel Worksheet Functions | |||
| Formatting of Data from .CSV file | Excel Worksheet Functions | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
Threaded Mode
