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.