Is there a way to insert dashes in a column of numbers

[Mickie]

Hi!
I have a column of numbers (2100 to be exact) that I need to insert dashes
so they resemble 333-33-3333. The numbers currently show 333333333. Is
there anything I can do?
Thanks so much for any suggestions..

 

[Ron Coderre]

If you only need the numbers to *appear* as if they contain dashes, try this:

Select the range of numbers

From the Excel main menu:
<format><cells><number tab>
Category: Special
Type: Social Security Number

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Pete_UK]

Alternatively, if you want them to be changed permanently, then you can
enter this formula in B1, assuming your existing numbers start at A1:

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

Copy the formula down for as many entries as you have in column A. You
can fix the values in column B by highlighting all the cells, then
<copy>, then Edit | Paste Special | Values (check), OK and <Esc>, and
then delete column A as you no longer need it.

Ron's method is a bit quicker!

Hope this helps.

Pete

 

[Mickie]

Ron and Pete...you are wonderful...thanks so much!!!
It worked immediately....of course...ha!

 

[Pete_UK]

Thanks for feeding back.

Pete

 

[CLR]

Another alternative would be.........

=TEXT(A1,"???-??-????")

Vaya con Dios,
Chuck, CABGx3

 

[Mickie]

Thanks so much Chuck!

Another alternative would be.........

=TEXT(A1,"???-??-????")

Vaya con Dios,
Chuck, CABGx3