#1
|
|||
|
|||
How to see original numbers on a CSV file
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. |
#2
|
|||
|
|||
I can't really replicate it but it sounds like excel is converting the number to scientific formula on saving it. This can happen when you have numbers as text and you choose the convert to number option in the drop down option, see picture.
Before you save the file select the numbers and convert them to text. If you save them in scientific format it looks like the before in the example but if you save them as numbers it looks like the after |
#3
|
||||
|
||||
I don't know Indesign from a hole in the ground, but you can't control the format of what's stored in CSV except, as SteveWcg says, by converting to text strings. I don't recommend that, though; I'm assuming you want to import numeric values at the other end. I can't visualize exactly what the problem is; perhaps you could post the CSV and explain exactly how it isn't what you wanted?
|
#4
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |