#1   Report Post  
Posted to microsoft.public.excel.misc
Rob
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Rob
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add 5 to amounts <25, 10 to amounts 25<100, etc? Duke Excel Worksheet Functions 3 March 7th 06 03:21 AM
Formula Showing In A Cell Instead of Proper Result DanK New Users to Excel 2 March 4th 06 06:46 AM
HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL SNOWBREEZE3 Excel Worksheet Functions 1 October 13th 05 09:10 PM
Showing Duplicate Rows EaglesNest Excel Discussion (Misc queries) 4 March 26th 05 05:21 PM
formula in cell not showing result Leolin Excel Worksheet Functions 8 March 18th 05 05:36 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"