• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Zero cant be seen

Shayeebur

Shayeebur

Member
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.
 

Attachments

  • Formatting Zero.xls
    51.5 KB · Views: 4
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 :)
 
You must log in or register to reply here.
Back
Top