Function Displays Function, Not Result

  • Thread starter Thread starter Egan
  • Start date Start date
E

Egan

I may have erroneously set a switch in Excel. When I
enter a function Excel displays the result in the the
function cell instead of the result. In the past it was
displaying the results of the function as it should. This
occurs in all workbooks, so it appears to be a universal
setting in Excel.

Thanks
 
Egan,

Tools / Option / View tab / Windows options
Uncheck Formulas

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Thanks, Auk, but the Formulas box was unchecked.
-----Original Message-----
Egan,

Tools / Option / View tab / Windows options
Uncheck Formulas

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *




.
Click to expand...
 
Then : Are your cells maybe formatted as text.
If so : Format /Cells/Number tab/General

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Auk,

That did it. Thanks so much, I did a lot of searching
through help before I posted my question.
 
And then re-enter the formulas, which can easily be done by Finding all "="
and replace them all with "="

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Obviously not necessary in this case

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
It was for me Niek.
I keep forgetting mentioning that.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
YW Egan,

What wonders me however is : you mentioned that it occured in all your
workbooks.
This however is a "setting" per cell or (might be) per sheet.

How did you manage to set all your cells in all sheet in all your workbooks
to set to Text. ????

It's not important but it puzzles me a bit.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top