How to zero fill a number inside of an Excel cell

calendar_today Asked Mar 12, 2009

thumb_up 25 upvotes

history Updated April 16, 2026

Question posted 2009 · +10 upvotes

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

Accepted answer +25 upvotes

=TEXT(A1,”0000000000″)

Top `excel` Q&A (6)

Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
Convert xlsx to csv in linux command line +96 (2012)
How to create a link inside a cell using EPPlus +50 (2011)
IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
T-SQL: Export to new Excel file +44 (2012)

+25 upvotes ranks this answer #20 out of 167 excel solutions on this site — top 12%.