Showing Zero amounts

R

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
 
P

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
 
R

Rob

Perfect!!

Thanks Peo.

Rob

Peo Sjoblom said:
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
Click to expand...
 
Top