Showing Zero amounts
 

I'd like to hide all Zero amounts on a spreadsheet except for a few selected
cells. Is there a way to do this?

Rob

Showing Zero amounts
 

You can use a custom format for all cells like

General;-General;;

then those that you want to show you can use

General

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Rob" <none wrote in message
...
I'd like to hide all Zero amounts on a spreadsheet except for a few
selected cells. Is there a way to do this?

Rob

Showing Zero amounts
 

Perfect!!

Thanks Peo.

Rob

"Peo Sjoblom" wrote in message
...
You can use a custom format for all cells like

General;-General;;

then those that you want to show you can use

General

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Rob" <none wrote in message
...
I'd like to hide all Zero amounts on a spreadsheet except for a few
selected cells. Is there a way to do this?

Rob