Hi
If i entet 0 (zero) in any cell in this sheet it wont display 0 but if i enter anything other than zero value it can be seen. Can anyone explain what kind of formatting done to this workbook.
Depending on your version of application you will have to find this. I have Excel 2010 so here I have to goto File | Options | Advanced | Display options for this worksheet | Show a zero in cells that have zero value
The option will be "unchecked" so you have to "check" it to display 0s.
In 2007 it is through the office button at top left and for 2003, if I remember correctly, Tools | Options. And as for 2013, I don't have any idea where it'd be