Cell Masking in Excel

[villy]

Hi All,

I'm here again as this is always my last resort, I already look through different post about something called mask display in excel.
Is it possible to mask the actual value of a cell?
For ex. If I have a value of 1 in "B1" as a result of a function for instance (SUM), Is it posibble that in cell "B1" instead of displaying 1 I want the display to be 0 for example.. Is there a way to do it (even in VBA) or is there so called cell masking?

I know this is something weird but if there is anyone with a brilliant ideas much appreciated. thanks

regards,
villy_voo

________________________________
"Share the blessing and you'll be more blessed."

 

[villy]

Thanks Jaafar that was good appreciated it...

I just finished my new project just did some tricks
thanks anyway surely I can still use it in my other projects.