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: 542
Default keeping a cell blank

how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks

 
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
Average Formula to display blank cell if named range is blank Rachael F Excel Worksheet Functions 3 February 22nd 08 05:05 PM
how to merge many cell to one cell with keeping all data Valley Excel Worksheet Functions 0 August 25th 06 01:12 PM
Keeping a cell reference. GeorgeH Excel Discussion (Misc queries) 1 March 26th 06 11:55 PM
Keeping the cell blank... JP New Users to Excel 3 May 5th 05 09:39 AM
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. QUEST41067 Excel Discussion (Misc queries) 1 January 15th 05 09:29 PM


All times are GMT +1. The time now is 04:46 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"