We are running Excel 2003. The data was imported into Excel. We want to
get the total of 3 columns. However, we got the error message in the Total
cell "#VALUE!". We resize the Total cell and it still did not work. The 3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell "#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom. The
Total cell still shows "#VALUE!". Do you have any suggestions on how to fix
the values in the 3 columns? Thanks.

Sounds like maybe the values you are trying to sum may have been copied from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want to
get the total of 3 columns. However, we got the error message in the Total
cell "#VALUE!". We resize the Total cell and it still did not work. The 3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell "#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom. The
Total cell still shows "#VALUE!". Do you have any suggestions on how to fix
the values in the 3 columns? Thanks.

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work. The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom. The
Total cell still shows "#VALUE!". Do you have any suggestions on how to
fix
the values in the 3 columns? Thanks.

We can narrow down, perhaps.

If you select one of the sum cells and click the = to the left of the
formula bar, it will provide which portion of the sum is not being recognized.

To be safe, it may be helpful if we could see a small sample of the data you
are attempting to sum.

Oh, and one other thought.. when you go to sum the columns, do you have,
say, =sum(A2:A4)? What formula are you putting in the sum cells?

"Diane Walker" wrote:

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work. The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom. The
Total cell still shows "#VALUE!". Do you have any suggestions on how to
fix
the values in the 3 columns? Thanks.

Thanks very much for your prompt response, Sean.

I selected one of the sum cells and click the = to the left of the formula
bar, I do not see anything. I used both formulas for sum cells
"=sum(A2:A4)" and "+A2+A3+A4". Do I need to format the columns in any
formats (Number, Currency, Accounting, etc.)? The columns came in as
General format. Do I need to format the Sum cells first before setting the
formulas? Below is the sample data. I need to add 675.00+923.30+933.30.
Please let me know if you have any other questions. Thanks.

675.00 923.30 933.30
675.00 826.70 770.00
925.00 826.70 860.00
750.00 910.00 893.30
575.00 920.00 826.70
350.00 910.00 750.00



"Sean Timmons" wrote in message
...
We can narrow down, perhaps.

If you select one of the sum cells and click the = to the left of the
formula bar, it will provide which portion of the sum is not being
recognized.

To be safe, it may be helpful if we could see a small sample of the data
you
are attempting to sum.

Oh, and one other thought.. when you go to sum the columns, do you have,
say, =sum(A2:A4)? What formula are you putting in the sum cells?

"Diane Walker" wrote:

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want
to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work.
The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom.
The
Total cell still shows "#VALUE!". Do you have any suggestions on how
to
fix
the values in the 3 columns? Thanks.

Sean,

I formatted the 3 columns and the total column to Number with 2 decimals. I
moved the cursor on one of the sum cells where the "!" is, it said "Value
used in the formula is of the wrong data type". I setup the formula in the
Sum cell as "+A2+A3+A4". Let me know if you have any questions or
suggestions. Thanks.

"Sean Timmons" wrote in message
...
We can narrow down, perhaps.

If you select one of the sum cells and click the = to the left of the
formula bar, it will provide which portion of the sum is not being
recognized.

To be safe, it may be helpful if we could see a small sample of the data
you
are attempting to sum.

Oh, and one other thought.. when you go to sum the columns, do you have,
say, =sum(A2:A4)? What formula are you putting in the sum cells?

"Diane Walker" wrote:

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want
to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work.
The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom.
The
Total cell still shows "#VALUE!". Do you have any suggestions on how
to
fix
the values in the 3 columns? Thanks.

Sean,

Sorry for sending you several messages. You know what I just found out. If
I formatted the 3 columns and the total column to Number with 2 decimals and
then manually reenter the numbers in the 3 columns, the total column works.
I noticed that the numbers in the 3 columns were entered left-justified
instead of
right-justified. It seemed that the 3 columns were formatted as Text
instead of Numeric when the file is imported. Maybe the solution is to
reimport the file and format those columns as Numeric unless you have other
suggestions. Thanks.

"Sean Timmons" wrote in message
...
We can narrow down, perhaps.

If you select one of the sum cells and click the = to the left of the
formula bar, it will provide which portion of the sum is not being
recognized.

To be safe, it may be helpful if we could see a small sample of the data
you
are attempting to sum.

Oh, and one other thought.. when you go to sum the columns, do you have,
say, =sum(A2:A4)? What formula are you putting in the sum cells?

"Diane Walker" wrote:

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want
to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work.
The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom.
The
Total cell still shows "#VALUE!". Do you have any suggestions on how
to
fix
the values in the 3 columns? Thanks.

Diane

You can Re-import but changing the format to Numeric won't do you any good.

Excel must be forced to see the data as Numeric.

One way is to format all to Number then copy an empty cell.

Select the data copy then, in place, Paste SpecialAddOKEsc.

Or select the data and DataText to ColumnsNextNextColumn Data
FormatGeneralFinish.

Now format to Number


Gord Dibben MS Excel MVP

On Wed, 31 Jan 2007 09:38:15 -0800, "Diane Walker" wrote:

Sean,

Sorry for sending you several messages. You know what I just found out. If
I formatted the 3 columns and the total column to Number with 2 decimals and
then manually reenter the numbers in the 3 columns, the total column works.
I noticed that the numbers in the 3 columns were entered left-justified
instead of
right-justified. It seemed that the 3 columns were formatted as Text
instead of Numeric when the file is imported. Maybe the solution is to
reimport the file and format those columns as Numeric unless you have other
suggestions. Thanks.

"Sean Timmons" wrote in message
...
We can narrow down, perhaps.

If you select one of the sum cells and click the = to the left of the
formula bar, it will provide which portion of the sum is not being
recognized.

To be safe, it may be helpful if we could see a small sample of the data
you
are attempting to sum.

Oh, and one other thought.. when you go to sum the columns, do you have,
say, =sum(A2:A4)? What formula are you putting in the sum cells?

"Diane Walker" wrote:

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want
to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work.
The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom.
The
Total cell still shows "#VALUE!". Do you have any suggestions on how
to
fix
the values in the 3 columns? Thanks.