Roger--what wonderful suggestions. I tried this "merged cells" with no luck,
and also the borders diagonally. Neither turned up anything. I did,
however, find in the computer files that for several months, there are two
bank reconciliations. One set has incorrect file names, so that there is an
unofficial reconciliation under a non-identifying file name, and an official
"balanced" reconciliation under a file name in which the contents are easily
recognizable. There is no reason for two reconciliations. It either
balances or it doesn't. Last year I did a reconciliation behind this person
and found completely made-up check amounts which didn't exist any where.
Subsequently this person stopped listing outstanding checks and just put in
totals of outstanding checks, making them impossible to trace. They did
include a calculator tape which supported the amount of O/S checks. The tape
is impossible to verify since it refers to nothing except amounts. I'm
wondering with two sets of working papers if there is a hiddden link or
reference. I only discovered this today, so have not had a chance to pursue
this.

Thanks so much for your input. This information may very well help uncover
future problems. This is all fascinating, and again I thank you for this
information.

"Roger Govier" wrote:

Hi

OK, then for something really bizarre, are any of the cells being added
Merged cells?
Try the following.
Put values in a set of adjacent cells down 2 columns.
Now, merge two empty horizontal cells in the same 2 columns and then use
the Format Painter to change the formats of the cells with your pairs of
data.
Only the left set of numbers in the newly merged cells will show up, but
if you highlight the cells and look at the sum in the calculation bar at
the bottom of the sheet, it will show the total of not just the visible
values on the screen, but also the "invisible" values in the merged
cells.

I remembered seeing a reference to this in the NG's before, and David
McRitchie uncovered the reason why in the thread as shown below.
http://snipurl.com/swz8 (thanks Gord!!)

It can also be "used" to hide formulae, so maybe there is a hidden
formula that "adjusts" the reconciled figure.
Could be a good way of "fiddling the books" and hiding the
discrepancy!!!!

--
Regards

Roger Govier


"catlover1946" wrote in message
...
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?