Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Numbers Beginning with Zero (Excel 2000)

    I need to know how to format numbers that keep the integrity of the numbers intact. Many of the numbers begin with a "0" zero. For example, 0224.

    How do I enter this text, without using the "'" single quote such that the zero is displayed?

    Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatting Numbers Beginning with Zero (Excel

    You can use a custom number format of 0000, then if you enter 224 it will display 0224 and will still be stored as a number.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Numbers Beginning with Zero (Excel

    Works perfect. Thanks.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Numbers Beginning with Zero (Excel 2000)

    It depends on what you want to happen. When you put the single quote in front of a number, it enters the value into the cell as text not a number. If this is what you want, then you can format the cell as Text BEFORE you enter the number into the cell. The number will then be entered into the cell as a text string with the leading zeroes. However, changing a cells format to Text after the number is entered will not convert the number into a text string.

    If you want the number to be entered into the cell as an Excel numeric value, but have leading zeros displayed, then you will need to do as Tony suggested and use a custom format.

    WARNING!!!! If you already have values entered with the single quote in front of them, and then you enter additional values using the Custom format, then you will have a mix of text and numeric values. This can result in some seemingly strange behavior when you do things like sort.
    Legare Coleman

Posting Permissions

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