Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clear 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. |
#2
|
|||
|
|||
Think zeros have been suppressed in the sheet ..
This is done via: Click Tools Options View tab Uncheck "Zero values" OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "carlos martinez" wrote in message ... 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. |
#3
|
|||
|
|||
....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 "Max" wrote in message ... Think zeros have been suppressed in the sheet .. This is done via: Click Tools Options View tab Uncheck "Zero values" OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "carlos martinez" wrote in message ... 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. |
#4
|
|||
|
|||
"KL" wrote:
...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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#5
|
|||
|
|||
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 -- Regards, Peo Sjoblom (No private emails please) "Max" wrote in message ... "KL" wrote: ...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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) | |||
Clear cell from formula? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |