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
 
Ad

Advertisements

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
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zeros Not Showing 4
Show Zeros 1
Show zero 2
Hide row if dollar amount is zero 5
Show zero values 4
Show leading zeros. 6
showing zero in cell 5
show zero as dash 2

Top