Formulas Appearing in Cell Instead of Result - EXCEL for iMac

This is driving me crazy.  Sometimes, I enter a formula and it only shows the formula, not the result.  How can this be fixed to return the RESULT in the cell instead of the reiteration of the formula I just entered?

Respectfully,

DAVID_G#

Answer
Answer

Check the cell formatting (Ctrl+1 > Number) and make sure that it's not formatted as Text. If it is, then change the format to something else, then F2 > Enter on the cell to coerce the format change and calculate.

HTH

Every once in a while there's a sudden gust of gravity...

15 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

https://support.office.com/en-us/article/Display-formulas-in-cells-44e98555-bd2b-4546-9e28-e9bc5fe25b28

The article is for displaying. Deselecting would revert back to normal view.

Sincerely yours,
Vijay A. Verma @ https://excelbianalytics.com

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 17, 2024 Views 10,831 Applies to: