Function Displays Function, Not Result

[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

 

[A.W.J. Ales]

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 *

 

[Egan]

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 *




.

 

[A.W.J. Ales]

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 *

 

[Egan]

Auk,

That did it. Thanks so much, I did a lot of searching
through help before I posted my question.

 

[Niek Otten]

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

 

[Niek Otten]

Obviously not necessary in this case

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[A.W.J. Ales]

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 *

 

[A.W.J. Ales]

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 *