Help with imprting a csv file into excel

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

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
>
>
>

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" <Kanan@discussions.microsoft.com> wrote in message
news:1A278CC1-EA49-4F5A-A97B-E3122A75235E@microsoft.com...
> 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
> >
> >
> >

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" <Kanan@discussions.microsoft.com> wrote in message
> news:1A278CC1-EA49-4F5A-A97B-E3122A75235E@microsoft.com...
> > 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
> > >
> > >
> > >
>
>
>

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" <Kanan@discussions.microsoft.com> wrote in message
news:B3F633F5-1DF2-4D77-9039-2FE8425039E3@microsoft.com...
> 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" <Kanan@discussions.microsoft.com> wrote in message
> > news:1A278CC1-EA49-4F5A-A97B-E3122A75235E@microsoft.com...
> > > 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
> > > >
> > > >
> > > >
> >
> >
> >

Thank you, the 'Data->Import Data' menu option helped solve the issue.

Ajmister

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:uaFl10iCFHA.1932@TK2MSFTNGP14.phx.gbl...
> 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" <Kanan@discussions.microsoft.com> wrote in message
> news:B3F633F5-1DF2-4D77-9039-2FE8425039E3@microsoft.com...
> > 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" <Kanan@discussions.microsoft.com> wrote in message
> > > news:1A278CC1-EA49-4F5A-A97B-E3122A75235E@microsoft.com...
> > > > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>