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.

Need to add a "0" at start of column in Excel

Discussion in 'Other PC Software' started by maxmangion, 2002/09/17.

Thread Status:
Not open for further replies.
  1. 2002/09/17
    maxmangion

    maxmangion Inactive Thread Starter

    Joined:
    2002/08/13
    Messages:
    252
    Likes Received:
    0
    I have a column in excel consisting of a number with 5 digits.

    254897
    264789
    245269

    Now i need to add a 0 to these number in front of them

    0254897
    0264789
    0245269

    Is this possible or do i have to change all of them manually?

    Thanks
     
    maxmangion,
    #1
  2. 2002/09/17
    Hex92

    Hex92 Inactive

    Joined:
    2002/01/08
    Messages:
    153
    Likes Received:
    0
    Use the 'concatenate' command.

    make a new column with 0s in it and concatenate it with your existing columns

    ie:
    concatenate(A1,B1)

    :cool:
     
    Hex92,
    #2


  3. to hide this advert.

  4. 2002/09/17
    WhitPhil

    WhitPhil Inactive

    Joined:
    2002/01/07
    Messages:
    599
    Likes Received:
    4
    You can use Format > Cells > Custom
    Highlight the Type: field and enter
    0000000

    This will place leading zeros in the field.
     
    Last edited: 2002/09/17
    WhitPhil,
    #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...