Ask Experts Questions for FREE Help !
Ask
    dragster1090's Avatar
    dragster1090 Posts: 24, Reputation: 1
    New Member
    		  
    #1

    Jun 3, 2013, 07:24 AM
    Add leading zero in excel
    How do I add a add leading zero in a cell in excel
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jun 3, 2013, 07:32 AM
    by converting it to a text value.
    Kevin-Radstock's Avatar
    Kevin-Radstock Posts: 8, Reputation: 3
    New Member
    		  
    #3

    Jun 3, 2013, 11:31 PM
    Not seeing what your data is like. If for instance you want 6 digits then format the cells as "000000" (without the quotes), this will display leading zero's ie: 123: 000123. Otherwise text.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

In Excel 2003 how do I add two spaces in a cell before the text [ 8 Answers ]

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Excel 2010 formula help I want to add a1 throgh z1 but if it is a (-) amount I want I [ 1 Answers ]

Excel 2010 formula help I want to add a1 through z1 but if it is a (-) amount I want it to not count as a or -

ESSBase EXCEL add-in, is there a version of the install that does not require admin are [ 0 Answers ]

ESSBase EXCEL add-in, is there a version of the install that does not require admin rights?

View more questions Search