Leolin

Either you are in Formula View or the cells are formatted as text.

For the first, hit CTRL + `(back quote above TAB key) to toggle View Formulas
on/off.

For the second, Format the cells to General then F2 and ENTER to see results.

If you have already done a great whack of these formulas, select all and
EditReplace

what: =
with: =

Replace All and OK.


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 21:17:02 -0800, Leolin
wrote:

Hi,

I have having a problem with the formular i type in a cell doesn't respond
by giving hte answer, however it just shows the formula like it is
text.....how do you format the cell to show the formula answer.

Thanks.