Formulas Not Working
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 |
Formulas Not Working
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 |
Formulas Not Working
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 |
Formulas Not Working
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 |
Formulas Not Working
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 | | |
Formulas Not Working
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 |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com