Inserting Dashes in a Column
 

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

Inserting Dashes in a Column
 

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

Inserting Dashes in a Column
 

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

Inserting Dashes in a Column
 

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