+ Reply to Thread
Results 1 to 4 of 4

How do I display an insignificant 0 at the beginning of a number

  1. #1
    nuttylocke
    Guest

    How do I display an insignificant 0 at the beginning of a number

    I am trying to display a number (eg 123456) with a 0 (zero) at the beginning
    (eg 0123456). Since excel does not display an insignificant zero by default,
    can anyone tell me how I can do this and apply the rule to a list of cells
    that already contain a 7 digit number without having to re-enter the
    information.

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Select the cell. Click FORMAT > CELLS. Select CUSTOM in the list. In the TYPE box, enter
    0000000
    i.e. seven zeros.

    - Mangesh

  3. #3
    Jason Morin
    Guest

    Re: How do I display an insignificant 0 at the beginning of a number

    Go to Format > Cells > Number tab and click "Custom".
    Under "Type" put: 0000000

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >I am trying to display a number (eg 123456) with a 0

    (zero) at the beginning
    >(eg 0123456). Since excel does not display an

    insignificant zero by default,
    >can anyone tell me how I can do this and apply the rule

    to a list of cells
    >that already contain a 7 digit number without having to

    re-enter the
    >information.
    >.
    >


  4. #4
    Guest

    How do I display an insignificant 0 at the beginning of a number

    hi,
    you can pre-format the cell to text.
    or create a custom format by going to format>cell>number
    tab>custom and enter 0000000. but this will only change
    how the number looks. it will appear in the cell as
    0123456 but in the formula bar it will appear as 123456.
    if you copy and paste the number into another workbook or
    application it will apear 123456.

    >-----Original Message-----
    >I am trying to display a number (eg 123456) with a 0

    (zero) at the beginning
    >(eg 0123456). Since excel does not display an

    insignificant zero by default,
    >can anyone tell me how I can do this and apply the rule

    to a list of cells
    >that already contain a 7 digit number without having to

    re-enter the
    >information.
    >.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1