Results 1 to 3 of 3

Thread: Need help to add default numbers with leading zeroes in Microsoft Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    123

    Need help to add default numbers with leading zeroes in Microsoft Excel

    See subject. I am using Office 2003 and wish to log series of 3 - 5 digit serial numbers and also record similar numbers in random order but excel persists in deleting leading zeros unless I enter the figures as as text. Thanks.

  2. #2
    Join Date
    Aug 2011
    Posts
    566

    Re: Need help to add default numbers with leading zeroes in Microsoft Excel

    A "number" with a leading zero IS text, not a real number. Entering it as TextFormat will preserve it's state. If you want to enter a "real number" and make it look like it has a leading zero, that can be done with Custom Formatting.

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: Need help to add default numbers with leading zeroes in Microsoft Excel

    You must either enter them as text or custom format the cell. For example, Format/Cells/Number/Custom Type: "000" or "00000". If you custom format the cells as above, you will not need to enter the leading zero's. If you want to enter a variable number of leading zeros, unless there is some method of determining the correct number of leading zero's, you will have to enter as text.

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 01:03 PM
  2. What is the way to interpolate numbers in Microsoft Excel
    By Tur^turro in forum MS Office Support
    Replies: 6
    Last Post: 21-01-2012, 02:23 PM
  3. How to open mac .numbers extenstion files on Microsoft Excel
    By TheCarter in forum MS Office Support
    Replies: 2
    Last Post: 18-01-2012, 05:41 PM
  4. How to Format a cell to keep leading zeros in Microsoft Excel
    By Raju Chacha in forum MS Office Support
    Replies: 3
    Last Post: 14-01-2012, 07:05 PM
  5. How to find frequency of lottery numbers in Microsoft Excel
    By Aarti C in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 01:52 PM

Tags for this Thread

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
  •  
Page generated in 1,711,650,043.58460 seconds with 17 queries