Well, you could use a formula if AA111122223 never changes the number of
characters.

Assume AA111122223 is in A1.
=concatenate(left(a1,2),"-",mid(a1,4,4),"-",mid(a1,7,4),"-",right(A1,1))

Dave
--
Brevity is the soul of wit.


"maryj" wrote:

Client needs to change existing values from AA111122223 to AA-1111-2222-3. Is
there any way to do this with custom formatting? Or what other options might
there be? Thanks!
--
maryj