| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with saving documents as .csv file
I have a table in excell with part numbers like 23A12, 837B2, 12E32...
When I want to save this documents as .csv type of file, excell converts codes that contains E in scientific format of numbers. So part number 12E32 converts to 1,20E+33! Can someone please help me with this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with saving documents as .csv file
You sure?
I put those values in a new worksheet (I had to make sure that the last field was text before I typed it in) and then created a .csv file. I opened that .csv file in NotePad and saw my text values. But... If I opened the .csv file in excel, then excel saw that last value as a number. If you have to open the CSV file in excel, then rename it to .txt first. Then when you do File|Open, you can specify that each field is text in the data import wizard. wrote: I have a table in excell with part numbers like 23A12, 837B2, 12E32... When I want to save this documents as .csv type of file, excell converts codes that contains E in scientific format of numbers. So part number 12E32 converts to 1,20E+33! Can someone please help me with this. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with saving documents as .csv file
your exporting a numeric field with field size: double.
change the field to text and problem solved. Cloggy "Dave Peterson" wrote: You sure? I put those values in a new worksheet (I had to make sure that the last field was text before I typed it in) and then created a .csv file. I opened that .csv file in NotePad and saw my text values. But... If I opened the .csv file in excel, then excel saw that last value as a number. If you have to open the CSV file in excel, then rename it to .txt first. Then when you do File|Open, you can specify that each field is text in the data import wizard. wrote: I have a table in excell with part numbers like 23A12, 837B2, 12E32... When I want to save this documents as .csv type of file, excell converts codes that contains E in scientific format of numbers. So part number 12E32 converts to 1,20E+33! Can someone please help me with this. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change default file for saving documents? | Excel Discussion (Misc queries) | |||
| Problem saving file as xls | Excel Programming | |||
| Saving Excel File in Current Directory NOT My Documents | Excel Programming | |||
| Saving Excel File in Current Directory NOT My Documents | Excel Programming | |||
| cannot open documents as viruscan says problem file? | Excel Discussion (Misc queries) | |||
Hybrid Mode
