Is there a way to keep the formatting in a cell, but hide the amounts? I have
a document that is adding amounts and my employer doesn't want to see the
running total all throughout the document. Any ideas??

You could hide the column containing the running total or change the text
colour to white (or your background colour).

"sunshine09" wrote:

Is there a way to keep the formatting in a cell, but hide the amounts? I have
a document that is adding amounts and my employer doesn't want to see the
running total all throughout the document. Any ideas??

Select a white font color in all those cells. Or, if the layout permits,
hide the unwanted columns/rows. HTH Otto

"sunshine09" wrote in message
...
Is there a way to keep the formatting in a cell, but hide the amounts? I
have
a document that is adding amounts and my employer doesn't want to see the
running total all throughout the document. Any ideas??

Format the cells to Custom ;;;

You will still be able to see contents and/or formulas in the formula bar,
however.

If you want to hide them you must format the cells to ProtectionHidden then
protect the worksheet.


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 13:58:02 -0800, sunshine09
wrote:

Is there a way to keep the formatting in a cell, but hide the amounts? I have
a document that is adding amounts and my employer doesn't want to see the
running total all throughout the document. Any ideas??