| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number in text format in CSV file
16 digit number formatted as text in a csv file is truncated when the csv
file is opened in Excel ... actually the 16th digit is changed to a 0. For example, in the csv file, the text 1000000001423086 is shown as 1000000001423080 when the csv file is opened with Excel. Is there a setting in Excel 2003 and/or 2007 that will prevent this from happening? This specifically is invoice information generated by one system for loading into another so it's really important for the invoice numbers to be correct! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
