View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default Is there a way to insert dashes in a column of numbers

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


"Mickie" wrote:

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..