I ran into a similar problem when I imported a csv file. I found that there
was a character (probably space(s)) in front of the numbers. I did a find
(pasted in characters from one of the cells) and replace with an empty string
(replace with) and it fixed my problem. I had tired previous suggestions to
no affect. It was/were those unprintable characters in front of my numbers
that maintained the text format, once gone everything worked.

"Parry" wrote:

Tried that...several times and it still shows the formula and not the sum.
Sorry.
--
Novice
Thanks


"Rick Rothstein (MVP - VB)" wrote:

It sounds like the cell was formatted as Text when the formula was entered.
Try this... delete the entry in the cell, then change its format to General,
and then type the formula over again.

Rick


"Parry" wrote in message
...
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.