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
|
|