LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary D.
 
Posts: n/a
Default Suppressing zero value display in print-out

How do I not print 0.000 values.

I am able to hide zero values on the screen with conditional formatting, but
when I print the sheet the zero value cells are printing 0.000, I would like
to have the cells with 0.0000 in them print blank.

Thanks Gary D.
 
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
Suppressing print dialogue box sgrech Excel Discussion (Misc queries) 0 September 24th 05 12:14 PM
Sheet display vrs. Print Preview Byron Excel Discussion (Misc queries) 4 July 6th 05 03:55 PM
urgent , display to print questy Excel Discussion (Misc queries) 2 March 14th 05 11:45 PM
patterns display but do not print Noble1 New Users to Excel 1 March 1st 05 05:31 AM
How can I display and print all the data in a wrapped merged cell. lflinders Excel Discussion (Misc queries) 1 January 6th 05 02:05 AM


All times are GMT +1. The time now is 08:27 PM.

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"