Results 1 to 4 of 4
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Red face showing a zero in a cell

    I'm really sorry about this guys, but I can't remember how to get a zero to show in a number that I am entering into a cell. I looked in the excel options advanced and all I see in there is show a zero in cells that have a zero value, and that is checked.... I'm really embarrassed.. Oh Office '07.
    Humbely John
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    John,

    Where is the zero in the number? Are you talking about leading zeros as in 007? if so you need to setup a custom format
    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    t8ntlikly (2011-09-11)

  4. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    Yup I am talking about a leading 0. Thanks RG!
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  5. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by t8ntlikly View Post
    Yup I am talking about a leading 0. Thanks RG!
    You can set a custom format for the cell Ctrl+1, Select "Custom" for the category. and put 000 in the Type

    or you can use =TEXT(A1,"000") if you want to change the format that way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •