Dispaly error

  • Thread starter Thread starter John Bendel
  • Start date Start date
J

John Bendel

Our bookkeeper has done something to a worksheet that I
can not figure out, either how she did it or how to fix
it. The solution is probably staring me in the face but I
can not see it.

The sheet is displaying formulas not the results. I have
highlighted the areas and "reformatted" the cells without
them changing. Dates are not displaying properly either.
It is puzzling because it is only one sheet in a multi-
sheet workbook.

Thanks, in advance.

John
 
Type CTRL-` (accent grave, the key with the tilde to the left of the 1
and above the Tab on US keyboards)
 
Hi John!

Use:

Tools > Options > View
Remove check from "Formulas"
OK

You probably hit the Ctrl + ` toggle shortcut by accident.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top