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?

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?

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?

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?

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?

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?

Biff --what a great idea, and probably the only thing I have overlooked in
searching cells.

"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?

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?

I am confused

You say the worksheet is unprotected yet you claim to be able to unhide contents
in the formula bar.

If the sheet is unprotected, the formula bar contents WILL NOT be hidden.


Gord Dibben MS Excel MVP


On Fri, 7 Jul 2006 15:59:01 -0700, catlover1946
wrote:

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?

Of course you're correct. Thanks for pointing out this discrepancy. I hid
and unhid the formula display repeatedly in the desparate hope something
would click, since nothing else had worked. Protection is absolutely
necessary to complete this process. It was not my intent to put forth any
incorrect or misleading information. I'm an accountant, so financial
programs are my forte. In the "use it or lose it" watchlist, I apparently
lose it. I obiously remain a novice since Excel is not the primary software
I use. I've tried so many things I've confused myself, and forget where I've
been. I appreciate any input of whatever type. I'm amazed at the helpful
suggestions I've recieved so far.
Thanks for your insight,
Catlover1946

"Gord Dibben" wrote:

I am confused

You say the worksheet is unprotected yet you claim to be able to unhide contents
in the formula bar.

If the sheet is unprotected, the formula bar contents WILL NOT be hidden.


Gord Dibben MS Excel MVP


On Fri, 7 Jul 2006 15:59:01 -0700, catlover1946
wrote:

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?

I first checked to see what text color was used, and converted the entire
worksheet to black type face. All cells have only white background. None
are filled with colored background. Even if text and background color are
the same, the formula should be displayed in the formula bar when the cell is
selected. Since formulas in the formula bar can be hidden, I re-displayed
formula bar contents for the entire workbook.

"JLatham" wrote:

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?