Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Zero amounts
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Zero amounts
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" <none wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Zero amounts
Perfect!!
Thanks Peo. Rob "Peo Sjoblom" wrote in message ... 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" <none wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add 5 to amounts <25, 10 to amounts 25<100, etc? | Excel Worksheet Functions | |||
Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL | Excel Worksheet Functions | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
formula in cell not showing result | Excel Worksheet Functions |