Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-31-2011, 08:03 AM
KIM SOLIS KIM SOLIS is offline How to set a no-display value to cells with a no-value link Windows XP How to set a no-display value to cells with a no-value link Office 97
Novice
How to set a no-display value to cells with a no-value link
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

Hi Catalin,

I use the formula - and you got it right on the spot! (as usual) Thanks a lot!

I also viewed my excel options and much as I looked, i could not find the setting 'complex-show options for this worksheet' and the 'show a zero in cells with zero'. I think this is a more preferred option as i understand this is kind of 'set once-apply to all' setting.

Best regards,

Kim
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set a no-display value to cells with a no-value link Name - Display Name Jamal NUMAN Outlook 2 11-21-2010 09:52 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM
Display the cells which add up to a certain sum edbyford Excel 1 11-26-2009 01:30 PM
Display names Ineedhelp Outlook 1 05-12-2009 11:28 PM
Shapes Will Not Display JoeTx Visio 0 03-13-2008 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft