Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-01-2012
Member
 
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

Reply With Quote
  #2  
Old 14-01-2012
Member
 
Join Date: May 2011
Posts: 445
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.
Reply With Quote
  #3  
Old 14-01-2012
Member
 
Join Date: Jun 2011
Posts: 632
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.
Reply With Quote
  #4  
Old 14-01-2012
Member
 
Join Date: Jul 2011
Posts: 627
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Format a cell to keep leading zeros in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Need help to add default numbers with leading zeroes in Microsoft Excel Wisaal MS Office Support 2 17-02-2012 04:33 PM
Need help, leading zeros in java loukassm Software Development 1 15-12-2010 11:52 AM
java program to add leading zeros to a number. kamina23 Software Development 4 05-02-2010 06:15 PM
How can I Remove the Leading Zeros in SQL? PsYcHo 1 Software Development 4 04-02-2010 05:59 AM
EXCEL not display leading zeros Aasha Windows Software 3 22-10-2009 06:21 PM


All times are GMT +5.5. The time now is 06:31 AM.