Excel automatically hides any zeros at the front of a number. For instance, Excel changes 007563 to 7563. Sometimes, with customer, invoice, or product numbers the zeros are important.

This Excel video tip shows how to force Excel to show extra zeros.

 

 

 

 

 

 

 

 

 

 

 

 

 

Tags: Excel 2007, Just Tips

This entry was posted on Sunday, January 3rd, 2010 at 3:30 pm and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.