Thread: Formula Display
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sajay[_2_] sajay[_2_] is offline
external usenet poster
 
Posts: 13
Default Formula Display

It is just a fun!!
It happened with me also earlier.

it is because you have unknowingly pressed the shortcut key

Control + ~

[control + Tilde ]

it is a toggling key


"Rick Rothstein (MVP - VB)" wrote in
message ...
I think you have to re-enter the formula *after* you reformat the cell.

Rick


"Kimbanev" wrote in message
...
Sometimes a cell's formula displays on my worksheet instead of the
calculation. Why does this happen, and how can I fix it? I've tried
re-formatting the cell, but this does not fix the problem.