R Rob Apr 10, 2006 #1 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
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 Apr 10, 2006 #2 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
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 Apr 10, 2006 #3 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...
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...