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

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

If you actually want the dashes stored in a cell, the formula would look like:

=left(a1,3)&"-"&mid(a1,4,3)&"-"&right(a1,2)

--
Regards,
Fred


"PCLIVE" wrote in message
...
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

You need to format the cell. Click FormatCellNumberCustom then under Type
create your format thus:- 000-000-00

"cbanks" wrote:

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