| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I save an excel file with long number columns in cvs form.
I need to convert a 20 digit number column in an excel spread sheet to a csv
format but it keeps converting to scientific number. I have save column as Text, Number and general but no matter what format the long numbers still revert to scientific. the phone column which is 10 digits converts just fine. I am using excel 2003 sp3 thanks, Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I save an excel file with long number columns in cvs form.
Does the data look ok when you open the .CSV file in Notepad (or your favorite
text editor)? You will see that problem if you reopen the .csv file in excel. You could rename the file to *.txt and then use file|open and specify that those fields should be text in that text import wizard. Or you could use: Data|Import external data| (in xl2003 menus) And you'll see the same wizard. layman2003 wrote: I need to convert a 20 digit number column in an excel spread sheet to a csv format but it keeps converting to scientific number. I have save column as Text, Number and general but no matter what format the long numbers still revert to scientific. the phone column which is 10 digits converts just fine. I am using excel 2003 sp3 thanks, Jim -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I save an excel file with long number columns in cvs form.
hi
excel has a 15 digit limit on true numbers. it should retain the 20 characters if you enter the number preceeded with an apostrophe.(text) i just did it in xp03. regards FSt1 "layman2003" wrote: I need to convert a 20 digit number column in an excel spread sheet to a csv format but it keeps converting to scientific number. I have save column as Text, Number and general but no matter what format the long numbers still revert to scientific. the phone column which is 10 digits converts just fine. I am using excel 2003 sp3 thanks, Jim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I save an excel file with long number columns in cvsform.
Are you looking at the csv file in Notepad?
layman2003 wrote: I need to convert a 20 digit number column in an excel spread sheet to a csv format but it keeps converting to scientific number. I have save column as Text, Number and general but no matter what format the long numbers still revert to scientific. the phone column which is 10 digits converts just fine. I am using excel 2003 sp3 thanks, Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Taking long time to save file to sub folder | Excel Discussion (Misc queries) | |||
| Save Excel file with certain columns with fixed width | Excel Discussion (Misc queries) | |||
| I can't save long file names, only short one, how can I do this? | Excel Discussion (Misc queries) | |||
| Long Save Times with File-Save | Excel Discussion (Misc queries) | |||
| Excel file takes a long time to save | Excel Discussion (Misc queries) | |||
Linear Mode
