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

[Raju Chacha]

Sponsored Links

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

[GaganjyotTechie]

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.

[QUENBY]

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.

[Leanne]

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.