Try this formula...

=A1 & REPT("0", 6-LEN(A1))
where your data is in cell a1
--
HTH...

Jim Thomlinson


"Alice M." wrote:

My column: Would like:

08-10 08-010
08-100 08-100
07-90 07-090
07-888 07-888

How do I add another 0 to change 08-10 to 08-010?