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#

 

Question Info


Last updated February 14, 2019 Views 4,361 Applies to:
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...

7 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

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.

Best regards
Vijay Verma

Timezone: UTC+05:30, PST+12:30
Availability Hours (UTC) : 05:00 AM - 06:00 PM

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.