Using font size 1 still leaves a tell-tale data mark in the cell. I can't
seem to find a way of using a smaller font. Also, the formula is still
displayed in the formula bar. Un-hiding the contents of the formula bar
revealed an empty cell. In order to reconcile a bank statement, all numbers
must be correct. The weird thing is that the numbers displayed add up to the
exact number needed to make the bank statement balance. But I know for a
fact the numbers used are incorrect. Is there any way to "overwrite" a cell,
but use the number underneath?

"Biff" wrote:

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?