Thread: Zero-Fill
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adam Aksu Adam Aksu is offline
external usenet poster
 
Posts: 1
Default 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" )