Thanks for the input. It is good to know. Doing this hides the cell
contents, but the formula bar still displays contents of the cell, unless you
hide the information displayed in the formula bar, and this trick is easy to
reverse, which I did. Nothing.

"Roger Govier" wrote:

Or FormatCellsNumberCustom;;; (3 semicolons)

--
Regards

Roger Govier


"Biff" wrote in message
...
Another trick is using a font size of 1.

Biff

"JLatham" wrote in message
...
Maybe the empty cells aren't really hidden? Perhaps they have text
color set
to background color, making them appear empty unless you select them
at which
time their contents will be revealed.

"catlover1946" wrote:

Excel 2003. Windows XP Professional. Bank reconciliations. How is
it
possible in an unprotected worksheet to hide additional data input
in
formulas so that visible invalid numbers produce accurate results?
Displaying
hidden formulas in formula bar reveals nothing. Blank cells have
been
included in formula, but searches for hidden numbers and links in
these cells
produced nothing. I'm at my wit's end to correct this misuse of
Excel in my
office. Any suggestions?