Try changing the format for your cells. Select your cells. Right-click on
them and select Format Cells. Under Category, select Custom. Type the
following:

###-###-##

Hope this helps,
Paul

"cbanks" wrote in message
...
12356789 in column a1

I want to put in column a2 123-567-89

Whats the formula to put dashed in between the numbers without havin to
retype 20000 numbers.

Thanks