Wednesday, February 26, 2014

Padding a numeric field with zeros in Excel

Use the Text function in Excel to pad a column with zeroes.

To pad to seven places, use the formula =TEXT(A1, "0000000").

Copy the values of this new column back to the original column, in the event that the original column is referenced in other formulas.

No comments:

Post a Comment

Followers