leading zeros
leading zeros
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: leading zeros

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I keep leading zeros from disappearing after I hit the enter key to move to another cell? I have already checked the zero values in the options/view. I seem to remember yoy first had to hit a certain key before the zero.

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-08 16:55, parish wrote:
    How do I keep leading zeros from disappearing after I hit the enter key to move to another cell? I have already checked the zero values in the options/view. I seem to remember yoy first had to hit a certain key before the zero.
    You can either put a quote (') before your entry, or if your values are all a constant length, you can custom format the cells that you will be entering the numbers in.

    For example, if you always want a 3-digit number with leading zeros, go to Format-Cells, click on Custom under Category (number tab), and type in "000" (no quotes) for your custom format. Then all of your cells will be 3 digit numbers even if you enter only one or 2 digits for your number.

    Hope this helps,

    Russell

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com