Formula shows not results
 

LOL

I have type a simple formula into a cell.

=SUM(A1:A13)

The formula appears after I press the enter button Check mark.... I press
the Fx and the results add up correctly.... yet the results do not appear
only the formula.

What have I done? Can I get the formula in the background and the results to
appear?

--
David

Formula shows not results
 

Format the cell with the formula as general or number (not text), then
reenter the formula (or just press F2 and enter)


--
Regards,

Peo Sjoblom



"David" wrote in message
...
LOL

I have type a simple formula into a cell.

=SUM(A1:A13)

The formula appears after I press the enter button Check mark.... I press
the Fx and the results add up correctly.... yet the results do not appear
only the formula.

What have I done? Can I get the formula in the background and the results
to
appear?

--
David

Formula shows not results
 

It sound like the cell is formatted as Text. Try:
Edit Replace Find What: enter =
Replace With: =

The cell will still be formatted as Text so chage the formatting to what you
want.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"David" wrote in message
...
LOL

I have type a simple formula into a cell.

=SUM(A1:A13)

The formula appears after I press the enter button Check mark.... I press
the Fx and the results add up correctly.... yet the results do not appear
only the formula.

What have I done? Can I get the formula in the background and the results
to
appear?

--
David

Formula shows not results
 

Does this occur with all formulas?

Perhaps you are in Formula View. Hit CTRL + `(backquote above Tab key)

OR

The cell was pre-formatted as Text.

Format to General then hit F2 then ENTER to re-enter the formula.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 14:51:02 -0700, David
wrote:

LOL

I have type a simple formula into a cell.

=SUM(A1:A13)

The formula appears after I press the enter button Check mark.... I press
the Fx and the results add up correctly.... yet the results do not appear
only the formula.

What have I done? Can I get the formula in the background and the results to
appear?

Formula shows not results
 

Yep, formatted as text.

Thanks
--
David


"Peo Sjoblom" wrote:

Format the cell with the formula as general or number (not text), then
reenter the formula (or just press F2 and enter)


--
Regards,

Peo Sjoblom



"David" wrote in message
...
LOL

I have type a simple formula into a cell.

=SUM(A1:A13)

The formula appears after I press the enter button Check mark.... I press
the Fx and the results add up correctly.... yet the results do not appear
only the formula.

What have I done? Can I get the formula in the background and the results
to
appear?

--
David