How to zero fill a number inside of an Excel cell

Question

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).

Answer 1

=TEXT(A1,"0000000000")

Answer 2

Not a programming question, really:

1. Select cells you want formatted in this way.
2. Right click and select "Format Cells..."
3. Select the "Number" Tag, and scroll down to "Custom" in the category list.
4. Type "0000000000" into the Type field.