formulas don't work

D

donny

Something strange is happening to a spreadsheet that I am
working on. Every time I try to add a formula to a cell it
stays as a forumla and does no calculations what's so ever
and yes I do have the = value in the formula bar. Is some
settings wrong? I even copied the whole worksheet and
pasted onto another spreadsheet and tried to calculate
formulas from another worksheet within that spreadsheet
and it did not recognize the values, it's like there's
nothing their, but there is. Please help me on this issue.
Thanks
 
M

Matthew Connor

donny said:
Something strange is happening to a spreadsheet that I am
working on. Every time I try to add a formula to a cell it
stays as a forumla and does no calculations what's so ever
and yes I do have the = value in the formula bar. Is some
settings wrong? I even copied the whole worksheet and
pasted onto another spreadsheet and tried to calculate
formulas from another worksheet within that spreadsheet
and it did not recognize the values, it's like there's
nothing their, but there is. Please help me on this issue.
Thanks

Goto to menu Tools | Options | View(tab) and uncheck 'Formulas'.


Good luck,

Matthew
 
G

Gord Dibben

donny

If Matthew's suggestion doesn't do the trick, perhaps the cells were
pre-formatted as Text.

Go to Edit>Replace

Replace what: = sign
Replace with: = sign

Also, the shortcut for toggling View Formulas on/off is CRTL + `(backquote
above TAB key)

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top