Thanks, but this didn't work either. Why is this so hard? I've even tried
to use a formula in another cell to total it, and still can't get a sum.
--
Novice
Thanks


"RagDyer" wrote:

Try this:

Select the cell with the text formula, then:
<Ctrl <Shift < ~
Then
<F2
Then <Enter

The first is a keyboard shortcut to format the cell to General.
The second is to enter the "Edit" mode.
And the 3rd is to register the formula.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.