How to see original numbers on a CSV file

macropod · #4 12-15-2013, 10:06 PM

Quote:

Originally Posted by mariocesar

I have an Excel workbook with a column of more than 35 numbers in it, when I save the file as CSV file because I'm importing in to Indesign later, the field with the 35 numbers changed to a different digit and also lettering, how can I the same numbers from original file.

Since Excel has only a 15-digit precision, any longer numeric string would already have to be stored as text. Such a string will be stored as such in the CSV. You can confirm that by opening the CSV file with a text editor like NotePad. Re-open the CSV in Excel, though and all you'll see is a number like 1.23456789012345E+39. Thus, this is a problem with the way Excel opens CSV files, not with how it stores CSV data.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'Save As' to same folder as original opened file	thepuppyprince	Office	0	01-18-2013 08:13 AM
Copy outline numbering retaining original numbers	PatPat	Word	7	08-20-2012 09:03 AM
Excel 2010 deleting original file and .tmp	msduh	Excel	1	04-09-2012 05:36 AM
How to restore original data format - from a .pdf file to Excel columns	KIM SOLIS	Excel	1	09-18-2011 10:49 PM
How to combine many word files in one file but to have correct pages numbers and tabl	Jamal NUMAN	Word	6	04-20-2011 02:32 PM