Formulas Not Working

[Guest]

Hi, I am trying to create a formula but excel will not recognize it as a
formula. Even a formula as simple as =1+1 will not work. When I hit enter it
still displays =1+1 instead of calculating the formula. I've tried a number
of different formulas all with the same result. Any ideas why it is not
working? Thanks

 

[Guest]

try

Ctrl+`

the last character is the key below the ESC key

 

[Bill Ridgeway]

You have the cell(s) formatted to text? Format to General and you'll be OK.
Go to <Format><Cells><General><OK>

Regards.

Bill Ridgeway
Computer Solutions

 

[Guest]

Sorry I forgot, ensure the cell you are using isn't formatted as text.

 

[Niek Otten]

And after formatting, re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| You have the cell(s) formatted to text? Format to General and you'll be OK.
| Go to <Format><Cells><General><OK>
|
| Regards.
|
| Bill Ridgeway
| Computer Solutions
|
| | > Hi, I am trying to create a formula but excel will not recognize it as a
| > formula. Even a formula as simple as =1+1 will not work. When I hit enter
| > it
| > still displays =1+1 instead of calculating the formula. I've tried a
| > number
| > of different formulas all with the same result. Any ideas why it is not
| > working? Thanks
|
|

 

[Guest]

That must have been the problem. I had inserted a number of rows & they were
the ones I was having trouble with. I just ended up dragging a different
formula over and started the formula over. It must have copied to format of
the cell which fixed the problem. Thank you for your fast response.