Friday, September 3, 2010


Keep The Leading Zeros In Excel Without Truncating

When you are trying to print the code "0128", the print result will be "128". And likewise, for the code "0008", the print result will be "8".
Related Topic:

What to do if you like to keep the "0" that in front (as in the screen shot) of the code in the printing result, is there any way to do this?
Excel truncate the leading zeros in case of numeric values by default. But if you would like to keep the leading zeros then you should use single code (‘) before the digit like for having 0008 you should use ‘0008. It is used like an escape character and you can still perform calculation using the cell. I you can try this directly in excel sheet. I am sure this will help you.


About bench3 -

Haja Peer Mohamed H, Software Engineer by profession, Author, Founder and CEO of "bench3" you can connect with me on Twitter , Facebook and also onGoogle+

Subscribe to this Blog via Email :