Showing Zero amounts

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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
 
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
 
Back
Top