Two ways:
If you want only to DISPLAY 5 digit values, use a custom format: 00000
If you really need 5 digit values, AND WORKING ON A COPY OF YOUR DATA,
insert a column temporarily, adjacent to your data. So, if your data is in
col A, insert a new col B. In the new cells use the formula:
=text(A1,"00000")
Copy it to all the pertinent cells
Select all these formulas & copy them
Select the original cells and use EditPaste SpecialValues
Delete the temporary column
"Bill R" wrote:
How do I add leading zeroes to data within an excel column. I'm trying to
convert data into total of 5 numerics by adding leading zeroes into the
string.
|