LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,069
Default printing without zeros showing in a cell with formulas

I've created a workbook that totals 5 worksheets (for Monday thru Friday) on
a 6th worksheet that is printed and posted weekly. However, because there is
a formula in each cell on the weekly sheet, a zero appears in all of the
cells which makes the sheet being posted look too too busy... Is there a way
to have the weekly worksheet leave all cells blank unless there is actual
data pulled?
 
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
Pictures not showing or printing JonEllwood Excel Discussion (Misc queries) 8 September 18th 06 10:31 AM
Leading zeros not showing MikeS Excel Discussion (Misc queries) 2 December 2nd 05 08:13 AM
Printing with the Headers showing on every page Dave Excel Discussion (Misc queries) 3 November 2nd 05 05:47 PM
leading zeros are not showing in the formula bar but do show in ce Debbie Excel Discussion (Misc queries) 2 October 2nd 05 03:26 PM
Printing but not showing Howard Excel Discussion (Misc queries) 4 February 28th 05 03:53 PM


All times are GMT +1. The time now is 09:54 PM.

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"