1. Home
  2. MS Office

How To Enter Values Starting With Zero In Excel 2010

By default, Excel 2010 omits zero if it is present in the first position of cell values. To keep zero as you move to next cell, you need to change the column/row/cell data type into Text data type. This will let you enter zero on first position.

To change into Text data type, right-click the column header and select Format Cells.

921d1277463473-enter-values-starting-zero-

This will open Format Cells dialog, from left sidebar, select Text and click OK.

920d1277463471-enter-values-starting-zero-

Now you can start entering zeros in column’s cells.

zeros

Note: Since it will change the data type to Text, you will not be able to apply any function or formula on this column.

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.