excelformattingworksheet-function

How to zero fill a number inside of an Excel cell

How do you zero fill a number to 10 positions inside an excel spreadsheet?

i.e. If cell A1 has 1234 how can cell A2 display 0000001234 (10 postions).

Solution 
  • =TEXT(A1,"0000000000")