How To Enter Values Starting With Zero In Excel ?
Application for Excel 2007, Excel 2010, Excel 2013 and Excel 2016
When an input value starts with zero, Excel will delete the zero by default. Rather than reset the Format Cells (Select cells -> Right click -> Select Format Cells -> Show Format Cells windown then left click on Number tab, select Text).
This problem can be easily solved by adding a single quote mark ahead of the first zero, as shown.
Application for Excel 2007, Excel 2010, Excel 2013 and Excel 2016
When an input value starts with zero, Excel will delete the zero by default. Rather than reset the Format Cells (Select cells -> Right click -> Select Format Cells -> Show Format Cells windown then left click on Number tab, select Text).
This problem can be easily solved by adding a single quote mark ahead of the first zero, as shown.
0 comments:
Post a Comment