Results 1 to 4 of 4

Thread: How to Format a cell to keep leading zeros in Microsoft Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    61

    How to Format a cell to keep leading zeros in Microsoft Excel

    I often deal with account numbers with leading zeros. When I place them in a cell Excel automatically deletes the leading zeros. Is there a way to format the cell to hold the zeros? If yes then please reply to me. Thanks

  2. #2
    Join Date
    May 2011
    Posts
    449

    Re: How to Format a cell to keep leading zeros in Microsoft Excel

    According to my information you can use custom number format. So for that you just have to set the custom number format to 000000 or as many zero as you need.

  3. #3
    Join Date
    Jun 2011
    Posts
    641

    Re: How to Format a cell to keep leading zeros in Microsoft Excel

    There are also one of the simple way to do this is by using another method, just try to use =FORMAT(A4,"0000000") which creates a string with the correct number of leading zeros, rather than just displaying it in this way.

  4. #4
    Join Date
    Jul 2011
    Posts
    638

    Re: How to Format a cell to keep leading zeros in Microsoft Excel

    According to my information the Excel has no FORMAT Function except in VBA. I think you may have meant =TEXT(A4,"0000000") This would leave the numbers as text and could not be readily used for calculations.

Similar Threads

  1. Replies: 2
    Last Post: 17-02-2012, 04:33 PM
  2. Need help, leading zeros in java
    By loukassm in forum Software Development
    Replies: 1
    Last Post: 15-12-2010, 11:52 AM
  3. java program to add leading zeros to a number.
    By kamina23 in forum Software Development
    Replies: 4
    Last Post: 05-02-2010, 06:15 PM
  4. How can I Remove the Leading Zeros in SQL?
    By PsYcHo 1 in forum Software Development
    Replies: 4
    Last Post: 04-02-2010, 05:59 AM
  5. EXCEL not display leading zeros
    By Aasha in forum Windows Software
    Replies: 3
    Last Post: 22-10-2009, 06:21 PM

Posting Permissions

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