ExcelBanter - How do I get the formula to show the result on the worksheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get the formula to show the result on the worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/24965-how-do-i-get-formula-show-result-worksheet.html)

kanye

How do I get the formula to show the result on the worksheet?

The Calculation in Tools is set to automatic & the result of the formula is
shown during Function; however, the result of the formula will not show on
the worksheet, just the formula itself.

JE McGimpsey

Your cell format is set to Text. Change the format of the cell to
General. Reenter the formula.

In article ,
"kanye" wrote:

The Calculation in Tools is set to automatic & the result of the formula is
shown during Function; however, the result of the formula will not show on
the worksheet, just the formula itself.

PegL

If that doesn't work, go to Tools;Options and uncheck the Formulas box on the
View tab, Window options.

"kanye" wrote:

The Calculation in Tools is set to automatic & the result of the formula is
shown during Function; however, the result of the formula will not show on
the worksheet, just the formula itself.

All times are GMT +1. The time now is 05:05 AM.