How to zero fill a number inside of an Excel cell

excel formatting worksheet-function
Gerhard Weiss picture Gerhard Weiss · Mar 12, 2009 · Viewed 65.4k times · Source

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

NakedBrunch picture NakedBrunch · Mar 12, 2009

=TEXT(A1,"0000000000")

Related questions

Excel CSV - Number cell format

I produce a report as an CSV file. When I try to open the file in Excel, it makes an assumption about the data type based on the contents of the cell, and reformats it accordingly. For example, if the …

Read More
(Excel) Conditional Formatting based on Adjacent Cell Value

I'm trying to apply conditional formatting in Excel on a range of cells, based on the adjacent cell's value, to achieve something like this: The goal is to highlight values in Column B (Actual Expense) red if the value is …

Read More
Ordering issue with date values when creating pivot tables

I have a 2-column spreadsheet which contains Dates and Sales figures as follows: When doing Right click -> Format Cells the values in the Dates column properly appear as Date (in the M/D/YYYY format). This applies to …

Read More