 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005Clear cell when value is 0
Dear All, I saw an excel spreadsheet whereby when a user enters any number in any cell the numbers remain with no change. But when a user enters 0 (number zero) in any cell, that specific cell becomes empty (clear of all contents) Please advice how can i do the same in my own spreadsheets! Thanking you in advance, Carlos. Think zeros have been suppressed in the sheet .. This is done via: Click Tools > Options > View tab > Uncheck "Zero values" > OK  Signature-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <at>yahoo<dot>com ---- > Dear All, > [quoted text clipped - 9 lines] > Thanking you in advance, > Carlos. ...just a comment: the zero does not dissappear from the cell and the cell does NOT become "empty (clear of all contents)". They just become invisible. Regards, KL > Think zeros have been suppressed in the sheet .. > This is done via: [quoted text clipped - 21 lines] >> Thanking you in advance, >> Carlos. > ...just a comment: the zero does not dissappear from the cell and the cell > does NOT become "empty (clear of all contents)". They just become invisible. Correct, perhaps the line > > Think zeros have been suppressed in the sheet .. should have read as: > > Think zeros display have been suppressed in the sheet Signature-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <at>yahoo<dot>com ---- Although the OP probably meant the whole sheet another options would be to use custom format like 0.00;-0.00; that way one can control where one wants this done SignatureRegards, Peo Sjoblom (No private emails please) >> ...just a comment: the zero does not dissappear from the cell and the >> cell [quoted text clipped - 15 lines] > xdemechanik <at>yahoo<dot>com > ---- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.