if the length is fixed, and your text is in cell A1, then use:
=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&RIGHT(A1,2)

Mangesh



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