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

try

Ctrl+`

the last character is the key below the ESC key

"Joker" wrote:

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

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

"Joker" wrote in message
...
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

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

"Joker" wrote:

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bill Ridgeway" wrote in message ...
| 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
|
| "Joker" wrote in message
| ...
| 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
|
|

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.

"Joker" wrote:

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