Assuming that the text 1122AA is in cell A1 -

=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&RIGHT(A1,2)

Regards.

Bill Ridgeway
Computer Solutions

"JFlorindo" wrote in message
...
How do i format a text cell in Excel, for example: 1122AA to 11-22-AA