1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excel Hiding Zeros

Discussion in 'Other PC Software' started by dishon, 2004/01/09.

Thread Status:
Not open for further replies.
  1. 2004/01/09
    dishon

    dishon Inactive Thread Starter

    Joined:
    2002/02/05
    Messages:
    138
    Likes Received:
    0
    If I have an account number, 001234
    Excel displays it as, 1234

    How do I get it to display as 001234?
     
    dishon,
    #1
  2. 2004/01/09
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Format the cell(s) as Text
     
    PeteC,
    #2


  3. to hide this advert.

  4. 2004/01/12
    Maxwell T

    Maxwell T Inactive

    Joined:
    2002/04/02
    Messages:
    5
    Likes Received:
    0
    If you need the format to remain numeric - choose "Custom" (at bottom of Format Cells / Category list. In field to right - enter zeros that correspond to the number of places required. Ex: 000000 in the Custom Filed Format dialog would cause the cell value 123 to appear as 000123. In this way, it retains its ability to be used in formulas etc.

    Max
     
    Maxwell T,
    #3
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...