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:

Display Or Hide Zero Values In Excel 2007 

Converting Lotus 123 Files To Excel 

Excel Crashes Every Time While Closing The Document | Solution 

List Of All Shortcut Used With Microsoft Office Excel 

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.