Home |
Search |
Today's Posts |
#1
|
|||
|
|||
large numbers going from XLS to CSV
I am trying to save an excell file as a .csv file. I have one cell that
contains a 16 digit number and it wont save as text. It turns into "7777+15". How can I get it to save correctly. thanks Jim |
#2
|
|||
|
|||
large numbers going from XLS to CSV
If you open the .CSV file in Notepad, I bet your 16 digits show up nicely.
But if you reopen that file in excel, excel will try to make that field numeric--and excel only supports 15 significant digits. (and will format it in scientific notation to boot.) If you have to reopen it in excel, you can rename that .csv file to .txt. Then when you do File|open, you'll see the data import wizard. You'll be able to specify that this field be text and your 16 digits will be kept nicely. Jimv wrote: I am trying to save an excell file as a .csv file. I have one cell that contains a 16 digit number and it wont save as text. It turns into "7777+15". How can I get it to save correctly. thanks Jim -- Dave Peterson |
#3
|
|||
|
|||
large numbers going from XLS to CSV
Have you tried to convert this number to text with TEXT() ?
If your data is in A1, let B1 be TEXT(A1;"###############"). "Jimv" escreveu: I am trying to save an excell file as a .csv file. I have one cell that contains a 16 digit number and it wont save as text. It turns into "7777+15". How can I get it to save correctly. thanks Jim |
#4
|
|||
|
|||
large numbers going from XLS to CSV
Yes, thanks I have tried to convert it to text.
Let me reword my question. The problem happens when I save it as a .csv to be imported into a data base. The .csv is not seeing all 16 digits even if I change it to text in excel. So the result is the information does not get imported. Any thoughts? Thanks again Jim "Fred" wrote: Have you tried to convert this number to text with TEXT() ? If your data is in A1, let B1 be TEXT(A1;"###############"). "Jimv" escreveu: I am trying to save an excell file as a .csv file. I have one cell that contains a 16 digit number and it wont save as text. It turns into "7777+15". How can I get it to save correctly. thanks Jim |
#5
|
|||
|
|||
large numbers going from XLS to CSV
If the cell was formatted as text, then you typed in that 16 digit number, then
saved to a .csv, did you see all 16 digits when you looked at the file using notepad? Reimporting the file into excel will cause the trouble you see. Jimv wrote: Yes, thanks I have tried to convert it to text. Let me reword my question. The problem happens when I save it as a .csv to be imported into a data base. The .csv is not seeing all 16 digits even if I change it to text in excel. So the result is the information does not get imported. Any thoughts? Thanks again Jim "Fred" wrote: Have you tried to convert this number to text with TEXT() ? If your data is in A1, let B1 be TEXT(A1;"###############"). "Jimv" escreveu: I am trying to save an excell file as a .csv file. I have one cell that contains a 16 digit number and it wont save as text. It turns into "7777+15". How can I get it to save correctly. thanks Jim -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting numbers beginning with zero | Excel Worksheet Functions | |||
quick Q about large numbers | Excel Discussion (Misc queries) | |||
Ploting data with a large range including negative numbers | Charts and Charting in Excel | |||
Validating random numbers | Excel Worksheet Functions | |||
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS | Excel Worksheet Functions |