M
mewild58
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!
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!