I found a general cell, put a one in it, copied it to the cell in question
that kept showing the formula...and now I have a total, but it's wrong.
Instead of 17.00 it's 0.00. I also don't know what you mean by Paste Sepcial
using the Multiply operation...so I couldn't do that. Can you be more
specific?
--
Novice
Thanks


"Ken Johnson" wrote:

On Jun 20, 10:48 am, Parry wrote:
Hi Dave...this worked for a couple of other formulas, but not for the ones in
question. I'm running Excel 2007. I'm stumped. Can you help?
--
Novice
Thanks

"Dave" wrote:
Hi,
In earlier versions, Tools menu, Options.
On the View tab, deselect Formulas.
Not sure how this differs for 2007
Regards - Dave.

Reformatting from Text to Number doesn't fix the problem of the cells
being treated as Text. Enter a 1 into a free cell that is definitely
General format then copy it then select E27:E42 and Paste Special
using the Multiply operation. The Sum should then be OK if that was
the problem.

Ken Johnson