1. 2010/01/08

   

   CUISTech Inactive Thread Starter

   Joined:

   2008/10/28

   Messages:

   419

   Likes Received:

   1

   I'm copying down a series of numbers from a written log. Each number is a 6-digit sequence that counts up to a certain point and resets, which means record #1 is recorded as 000001.
   
   Is there a custom cell format I can create in Excel to fill the left with 0? Make it check for 6 digits, and if there aren't, add 0s until there are?

    

   CUISTech,

   #1
2. 2010/01/08

   

   PeteC SuperGeek Staff

   Joined:

   2002/05/10

   Messages:

   28,896

   Likes Received:

   389

   See if this applies - courtesy of Google ...
   
   Show Leading Zeroes in Microsoft Excel
   
   How to display leading zeros for a fixed-length number in Excel

    

   PeteC,

   #2

3. 
   Log in or Sign up to hide this advert.

• Log in with Facebook
• Log in with Twitter
• Log in with Google

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in