|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have tried and succeeded in importing a .csv file into excel. This file has
numerical values. After converting the file, I try and add a few of the
numbers in one of the colunms and my answer is always #VALUE; which tells me
those numbers are being read as values and not numbers. HOW do I import the
file or what changes do I need to make in order to get those numbers to be
seen as Numerical after the file is imported?
|
|
If you can change the name of the file you are importing into excel to one
ending in .txt you will get the import wizard open and that will allow you
to change formatting for columns.
If this is not a solution, there is an Add-in available (free) called ASAP
Utilities that can help in changing the numbers to actual numbers rather
than text
"d_kight" <dkight[ at ]discussions.microsoft.com> wrote in message
news:FC43566F-D4AB-4AD6-B99B-76808015BCFE[ at ]microsoft.com...
[Quoted Text] >I have tried and succeeded in importing a .csv file into excel. This file
>has
> numerical values. After converting the file, I try and add a few of the
> numbers in one of the colunms and my answer is always #VALUE; which tells
> me
> those numbers are being read as values and not numbers. HOW do I import
> the
> file or what changes do I need to make in order to get those numbers to be
> seen as Numerical after the file is imported?
|
|
thanks Gail, However, the import wizard seems to work fine coming form a .csv
file going to a .xl file (or so it seems). Are you suggesting that I re-save
the .csv file as a .txt file THEN use the Import wizard in Excel?
"Gail" wrote:
[Quoted Text] > If you can change the name of the file you are importing into excel to one
> ending in .txt you will get the import wizard open and that will allow you
> to change formatting for columns.
>
> If this is not a solution, there is an Add-in available (free) called ASAP
> Utilities that can help in changing the numbers to actual numbers rather
> than text
>
> "d_kight" <dkight[ at ]discussions.microsoft.com> wrote in message
> news:FC43566F-D4AB-4AD6-B99B-76808015BCFE[ at ]microsoft.com...
> >I have tried and succeeded in importing a .csv file into excel. This file
> >has
> > numerical values. After converting the file, I try and add a few of the
> > numbers in one of the colunms and my answer is always #VALUE; which tells
> > me
> > those numbers are being read as values and not numbers. HOW do I import
> > the
> > file or what changes do I need to make in order to get those numbers to be
> > seen as Numerical after the file is imported?
>
>
>
|
|
Try this method? I think step 3 of this wizard is where you will find a
solution.
From the menu bar
Data | Import External Data | Import Data
When the open file window comes up, choose File Types with the .csv entry in
it. Continue on and identify your file and then the Wizard gets started for
real. Make sure that you set things along the way, like the separator
itself. In Step 3 of 3 make sure that all columns are set to "General" type.
That should import numbers as numbers, text as text, dates as dates, etc.
Before you start you might want to select all the cells on your worksheet
and use Edit | Clear | Format
to make sure that the cells/columns on it are not formatted as Text. I'm
not certain if the choice made with the data import wizard overrides any
formatting already on a sheet or not right at this moment.
"d_kight" wrote:
[Quoted Text] > thanks Gail, However, the import wizard seems to work fine coming form a .csv
> file going to a .xl file (or so it seems). Are you suggesting that I re-save
> the .csv file as a .txt file THEN use the Import wizard in Excel?
>
> "Gail" wrote:
>
> > If you can change the name of the file you are importing into excel to one
> > ending in .txt you will get the import wizard open and that will allow you
> > to change formatting for columns.
> >
> > If this is not a solution, there is an Add-in available (free) called ASAP
> > Utilities that can help in changing the numbers to actual numbers rather
> > than text
> >
> > "d_kight" <dkight[ at ]discussions.microsoft.com> wrote in message
> > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE[ at ]microsoft.com...
> > >I have tried and succeeded in importing a .csv file into excel. This file
> > >has
> > > numerical values. After converting the file, I try and add a few of the
> > > numbers in one of the colunms and my answer is always #VALUE; which tells
> > > me
> > > those numbers are being read as values and not numbers. HOW do I import
> > > the
> > > file or what changes do I need to make in order to get those numbers to be
> > > seen as Numerical after the file is imported?
> >
> >
> >
|
|
If it's a comma seperated file - it should load correctly.
what format is the data ?
and as mentioned - is it plain text
Steve
On Fri, 14 Jul 2006 17:41:02 +0100, d_kight =
<dkight[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > I have tried and succeeded in importing a .csv file into excel. This =
> file has
> numerical values. After converting the file, I try and add a few of th=
e
> numbers in one of the colunms and my answer is always #VALUE; which =
> tells me
> those numbers are being read as values and not numbers. HOW do I impo=
rt =
> the
> file or what changes do I need to make in order to get those numbers t=
o =
> be
> seen as Numerical after the file is imported?
|
|
Thanks Latham, I will definitely give that a go! and Steve, the format is in
..csv. Is that what you are refering to?
"JLatham" wrote:
[Quoted Text] > Try this method? I think step 3 of this wizard is where you will find a
> solution.
> From the menu bar
> Data | Import External Data | Import Data
> When the open file window comes up, choose File Types with the .csv entry in
> it. Continue on and identify your file and then the Wizard gets started for
> real. Make sure that you set things along the way, like the separator
> itself. In Step 3 of 3 make sure that all columns are set to "General" type.
> That should import numbers as numbers, text as text, dates as dates, etc.
>
> Before you start you might want to select all the cells on your worksheet
> and use Edit | Clear | Format
> to make sure that the cells/columns on it are not formatted as Text. I'm
> not certain if the choice made with the data import wizard overrides any
> formatting already on a sheet or not right at this moment.
>
> "d_kight" wrote:
>
> > thanks Gail, However, the import wizard seems to work fine coming form a .csv
> > file going to a .xl file (or so it seems). Are you suggesting that I re-save
> > the .csv file as a .txt file THEN use the Import wizard in Excel?
> >
> > "Gail" wrote:
> >
> > > If you can change the name of the file you are importing into excel to one
> > > ending in .txt you will get the import wizard open and that will allow you
> > > to change formatting for columns.
> > >
> > > If this is not a solution, there is an Add-in available (free) called ASAP
> > > Utilities that can help in changing the numbers to actual numbers rather
> > > than text
> > >
> > > "d_kight" <dkight[ at ]discussions.microsoft.com> wrote in message
> > > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE[ at ]microsoft.com...
> > > >I have tried and succeeded in importing a .csv file into excel. This file
> > > >has
> > > > numerical values. After converting the file, I try and add a few of the
> > > > numbers in one of the colunms and my answer is always #VALUE; which tells
> > > > me
> > > > those numbers are being read as values and not numbers. HOW do I import
> > > > the
> > > > file or what changes do I need to make in order to get those numbers to be
> > > > seen as Numerical after the file is imported?
> > >
> > >
> > >
|
|
JLatham,
I did everything that you suggested and I tried to add a couple of simple
numbers. I continue to come up with #VALUE!.
Is there something I am missing?
D_Kight
"JLatham" wrote:
[Quoted Text] > Try this method? I think step 3 of this wizard is where you will find a
> solution.
> From the menu bar
> Data | Import External Data | Import Data
> When the open file window comes up, choose File Types with the .csv entry in
> it. Continue on and identify your file and then the Wizard gets started for
> real. Make sure that you set things along the way, like the separator
> itself. In Step 3 of 3 make sure that all columns are set to "General" type.
> That should import numbers as numbers, text as text, dates as dates, etc.
>
> Before you start you might want to select all the cells on your worksheet
> and use Edit | Clear | Format
> to make sure that the cells/columns on it are not formatted as Text. I'm
> not certain if the choice made with the data import wizard overrides any
> formatting already on a sheet or not right at this moment.
>
> "d_kight" wrote:
>
> > thanks Gail, However, the import wizard seems to work fine coming form a .csv
> > file going to a .xl file (or so it seems). Are you suggesting that I re-save
> > the .csv file as a .txt file THEN use the Import wizard in Excel?
> >
> > "Gail" wrote:
> >
> > > If you can change the name of the file you are importing into excel to one
> > > ending in .txt you will get the import wizard open and that will allow you
> > > to change formatting for columns.
> > >
> > > If this is not a solution, there is an Add-in available (free) called ASAP
> > > Utilities that can help in changing the numbers to actual numbers rather
> > > than text
> > >
> > > "d_kight" <dkight[ at ]discussions.microsoft.com> wrote in message
> > > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE[ at ]microsoft.com...
> > > >I have tried and succeeded in importing a .csv file into excel. This file
> > > >has
> > > > numerical values. After converting the file, I try and add a few of the
> > > > numbers in one of the colunms and my answer is always #VALUE; which tells
> > > > me
> > > > those numbers are being read as values and not numbers. HOW do I import
> > > > the
> > > > file or what changes do I need to make in order to get those numbers to be
> > > > seen as Numerical after the file is imported?
> > >
> > >
> > >
|
|
|