LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default global zero suppress Excel 2007

I know I can go to the Office Button, then to Advanced, then to "Display
Options for this Workbook" and remove the check from the box for "Show a zero
in cells that have zero value", but I'm curious if there is a way to make
that the default for all worksheets by default so I can avoid manually
setting it each time??????
--
''''Bye from Big Al
 
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
Suppress Labels in Formulas Msg in 2007 JP Jones Excel Discussion (Misc queries) 0 January 8th 09 11:56 PM
Global find and replace in Excel 2007 Woodman Excel Discussion (Misc queries) 1 November 3rd 08 11:44 PM
How do I suppress repeating data in Excel Kent E. Excel Discussion (Misc queries) 0 July 3rd 08 09:24 PM
Suppress protection alerts in Excel Yohanne the Great Excel Discussion (Misc queries) 5 March 5th 06 10:06 PM
How to suppress leading zeros in Excel Jay Excel Discussion (Misc queries) 2 July 27th 05 01:07 AM


All times are GMT +1. The time now is 02:58 AM.

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

About Us

"It's about Microsoft Excel"