Showing Zero amounts

[Rob]

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

 

[Peo Sjoblom]

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]

Perfect!!

Thanks Peo.

Rob

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