| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with imprting a csv file into excel
in step 3 of the import wizard, highlight all columns and check the text box
on the top right. That should fix the problem. good luck kk "ajmister" wrote: Hi I am importing a .csv file into excel. One of the columns has values like 46120E60, 03235E10 etc. When the .csv file is imported into excel those values are changing from 46120E60, 03235E10 to 4.612E+64 and 3.24E+13. Any suggestions on how to fix that. Ajmister |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with imprting a csv file into excel
CSV files don't trigger the import wizard and if you use the opentext method
in VBA with a file with a .csv extension, then the setting specified in Opentext command are ignored. At least in most versions of excel. -- Regards, Tom Ogilvy "Kanan" wrote in message ... in step 3 of the import wizard, highlight all columns and check the text box on the top right. That should fix the problem. good luck kk "ajmister" wrote: Hi I am importing a .csv file into excel. One of the columns has values like 46120E60, 03235E10 etc. When the .csv file is imported into excel those values are changing from 46120E60, 03235E10 to 4.612E+64 and 3.24E+13. Any suggestions on how to fix that. Ajmister |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with imprting a csv file into excel
I tried the 'Data-Import Data' menu option, and then choose 'All Files'
under the 'files of Type' dropdown box for files with both .csv and .txt extension in EXCEL XP (2002). kk "Tom Ogilvy" wrote: CSV files don't trigger the import wizard and if you use the opentext method in VBA with a file with a .csv extension, then the setting specified in Opentext command are ignored. At least in most versions of excel. -- Regards, Tom Ogilvy "Kanan" wrote in message ... in step 3 of the import wizard, highlight all columns and check the text box on the top right. That should fix the problem. good luck kk "ajmister" wrote: Hi I am importing a .csv file into excel. One of the columns has values like 46120E60, 03235E10 etc. When the .csv file is imported into excel those values are changing from 46120E60, 03235E10 to 4.612E+64 and 3.24E+13. Any suggestions on how to fix that. Ajmister |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with imprting a csv file into excel
You are correct about that. I normally think of File=open in this context
and most of my testing has been in older verions. In any event, your response probably provided the OP some additional information. -- Regards, Tom Ogilvy "Kanan" wrote in message ... I tried the 'Data-Import Data' menu option, and then choose 'All Files' under the 'files of Type' dropdown box for files with both .csv and .txt extension in EXCEL XP (2002). kk "Tom Ogilvy" wrote: CSV files don't trigger the import wizard and if you use the opentext method in VBA with a file with a .csv extension, then the setting specified in Opentext command are ignored. At least in most versions of excel. -- Regards, Tom Ogilvy "Kanan" wrote in message ... in step 3 of the import wizard, highlight all columns and check the text box on the top right. That should fix the problem. good luck kk "ajmister" wrote: Hi I am importing a .csv file into excel. One of the columns has values like 46120E60, 03235E10 etc. When the .csv file is imported into excel those values are changing from 46120E60, 03235E10 to 4.612E+64 and 3.24E+13. Any suggestions on how to fix that. Ajmister |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with imprting a csv file into excel
Thank you, the 'Data-Import Data' menu option helped solve the issue.
Ajmister "Tom Ogilvy" wrote in message ... You are correct about that. I normally think of File=open in this context and most of my testing has been in older verions. In any event, your response probably provided the OP some additional information. -- Regards, Tom Ogilvy "Kanan" wrote in message ... I tried the 'Data-Import Data' menu option, and then choose 'All Files' under the 'files of Type' dropdown box for files with both .csv and .txt extension in EXCEL XP (2002). kk "Tom Ogilvy" wrote: CSV files don't trigger the import wizard and if you use the opentext method in VBA with a file with a .csv extension, then the setting specified in Opentext command are ignored. At least in most versions of excel. -- Regards, Tom Ogilvy "Kanan" wrote in message ... in step 3 of the import wizard, highlight all columns and check the text box on the top right. That should fix the problem. good luck kk "ajmister" wrote: Hi I am importing a .csv file into excel. One of the columns has values like 46120E60, 03235E10 etc. When the .csv file is imported into excel those values are changing from 46120E60, 03235E10 to 4.612E+64 and 3.24E+13. Any suggestions on how to fix that. Ajmister |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file opens MS Excel Training Webpage When the Excel file ope | Excel Discussion (Misc queries) | |||
| How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
| double click excel file on the desktop excel opens but not file? | Excel Discussion (Misc queries) | |||
| Excel 2003: doubleclick on file opens Excel window, not file. | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Hybrid Mode
