Create your custom format
I found it most easiest creating my own custom format to solve this.
1. Right click the cell range you want to format
2. In the tab 'Number' chose "Custom"
3. In the field 'Type' enter zeroes. Enter as many
zeroes as the preferred length of your numbers.
( e.g. for 10 digits enter "0000000000" )
|