In a helper column put this formula and copy down.....then do Copy
PasteSpecial Values on that helper column to eliminate the formulas and
delete the original column if desired.

=LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&MID(A1,6,99)

Vaya con Dios,
Chuck, CABGx3



"Jim Davis" <Jim wrote in message
...
I'm trying to change the format of the following"

12345678
to
123-45-678 -- in other words, adding the dashes. Some of the numbers are
the
same 8 digits, but also have a letter. They are currently:

12345678A
to
123-45-678A

Thank you,