Infero Training – Business and Technical Courses

Let’s say you want to format cells, so that you can display preceding zeroes for a number, for example, a phone number will always begin with a zero.

1. Select the cells that you want to format.
2. Right click on selected and from the menu choose the Format Cells
3. From the Number tab in the Category click on Custom.
4. Click in the Type box, delete the displayed content and enter zeroes that correspond to the size of the required number, for example if you want to display 5 numbers, enter 00000.
5. Click OK.

When you enter numbers into the formatted cells, the preceding zeroes will be displayed, for example if you formatted the cells as 00000, when you enter 123 you will get 00123