Forum Discussion
Solved
hovering over excel cell to see value works in some spreadsheets but not in others
I am using Microsoft 365 Version 2206 32 bit I have an cell on an excel sheet that when I change the number format to commas becomes a hashtag filled cell. This is okay as I use rounded numbers but...
Hi Spitz_012022
if you just want to see the results temporarily, just click in the formula bar of that cell and press F9 function key.
It will give you the result of the formula:
But do not press enter, otherwise it will replace the formula with that value. Instead, leave the formula bar by hitting ESC key.
Hi Spitz_012022
if you just want to see the results temporarily, just click in the formula bar of that cell and press F9 function key.
It will give you the result of the formula:
But do not press enter, otherwise it will replace the formula with that value. Instead, leave the formula bar by hitting ESC key.
Thank you for the response. It works but it is irritating that now you have to use an extra step for something that was automatic prior. Microsoft seems to not check the effects of their updates at times. Anyway thank you very much and have a good day.