Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scientific notation of CSV
There was a post like this from last year, but it only details the workaround
of changing the .csv to a .txt file. Is there a setting or anything else that would not attempt to change a long digit (like a zipcode or phone) into a scientific number when importing from a .CSV file - but leave it as a full number? (or text string of digits) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scientific notation of CSV
If you import it using dataimport external dataimport data, then type *.*
in the file name box, then browse until you find your file, open it this way then the text import wizard will start and you can import these values as text under column data format -- Regards, Peo Sjoblom "FASTWRX" wrote in message ... There was a post like this from last year, but it only details the workaround of changing the .csv to a .txt file. Is there a setting or anything else that would not attempt to change a long digit (like a zipcode or phone) into a scientific number when importing from a .CSV file - but leave it as a full number? (or text string of digits) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Almost
Thank you . . . that will work, but it's still extra steps we're trying to
avoid. I'm thinking there isn't a setting to standardize the import of all fields as text? (not each time) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scientific notation of CSV
That's exactly what the TXT business does. Allows you to force it to text.
FASTWRX wrote: There was a post like this from last year, but it only details the workaround of changing the .csv to a .txt file. Is there a setting or anything else that would not attempt to change a long digit (like a zipcode or phone) into a scientific number when importing from a .CSV file - but leave it as a full number? (or text string of digits) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Almost
You could record a macro while you do the manual steps once, and then
in future you will be able to re-run the macro to import the data how you want it. You may need to edit the recorded macro so that you can have a different filename etc next time. Hope this helps. Pete On Oct 24, 10:41 pm, FASTWRX wrote: Thank you . . . that will work, but it's still extra steps we're trying to avoid. I'm thinking there isn't a setting to standardize the import of all fields as text? (not each time) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scientific Notation Issues | Excel Worksheet Functions | |||
Scientific notation | Excel Worksheet Functions | |||
Scientific notation from a csv file | Excel Discussion (Misc queries) | |||
scientific notation | Excel Discussion (Misc queries) | |||
Scientific notation | Excel Discussion (Misc queries) |