Excel: insert zero before number series
Related Videos: How to enter zero before number in excel (May 2024).
In order to insert a 0 in front of a series of numbers in Excel, you have to do a little trick. Phone numbers, postcodes and other numbers are then displayed correctly. We'll show you how to do it.
Postal code and phone numbers: How to insert a 0 before Excel number series
- Right click on the cell and open the "Cell Format" and select "Custom" from the list. Enter "0" 0 here.
- However, in order to be able to calculate with the numbers, you have to proceed as follows.
- Enter "= TEXT (A2;" 0000000 ")" (without the first and last quotation marks) in the adjacent column.
- Now drag the cell on the corner over all fields where the zero has been automatically removed.
- All numbers are now correctly displayed again.
We have summarized the best tricks for calculating with formulas in Excel in this practical tip.