SIMPLE SUM FORMULA

[techjohnny]

Hey, Group:

I'd trying a simple sum formula on cells that already have existing
numbers. The formula is only reporting 0 when I try adding the cells
together, but if I change the cells value, the formula will start to
add the changes, but no existing numbers.

Versions: All
Worksheet: contains 15 columns and 950 linees
Other: All cells are type of general.

Kinda vague, but hopefully enough.

Thanks,

--TJ

 

[T. Valko]

One possibility:

There may leading/trailing spaces in your data. This makes the data TEXT.
When you manually retype the number you're not including those spaces.

Biff

 

[Elkar]

Sounds like your existing numbers have been entered as text values. Simply
changing the cell format may not switch them back to numbers. Try this:

Enter a 1 into any blank cell
Copy that cell
Select your range of existing numbers
From the Edit Menu, choose "Paste Special"
Select the options for "Values" and "Multiply"
Click OK
Delete the 1 you entered originally

By doing all of this, you have multiplied all your data by 1. Excel will
convert anything that looks like a number into a number without changing the
value.

HTH,
Elkar

 

[techjohnny]

Sounds like your existing numbers have been entered as text values. Simply
changing the cell format may not switch them back to numbers. Try this:

Enter a 1 into any blank cell
Copy that cell
Select your range of existing numbers
From the Edit Menu, choose "Paste Special"
Select the options for "Values" and "Multiply"
Click OK
Delete the 1 you entered originally

By doing all of this, you have multiplied all your data by 1. Excel will
convert anything that looks like a number into a number without changing the
value.

HTH,
Elkar








- Show quoted text -

Perfect. Thanks. I did exactly what you said, and now the formula
works!

--TJ