Formula won't show sum
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
|