Results 1 to 14 of 14

Reformat SSN to add dashes between numbers

Threaded View

wheatgrass Reformat SSN to add dashes... 06-12-2011, 04:51 PM
abishekmouli88 Re: Reformat SSN to add... 06-12-2011, 06:27 PM
wkelley Re: Reformat SSN to add... 01-17-2013, 12:11 PM
TMS Re: Reformat SSN to add... 06-12-2011, 06:32 PM
wheatgrass Re: Reformat SSN to add... 06-12-2011, 07:41 PM
jaslake Re: Reformat SSN to add... 06-12-2011, 08:08 PM
TMS Re: Reformat SSN to add... 06-12-2011, 08:28 PM
abishekmouli88 Re: Reformat SSN to add... 06-12-2011, 09:31 PM
wheatgrass Re: Reformat SSN to add... 06-13-2011, 08:34 AM
TMS Re: Reformat SSN to add... 06-13-2011, 08:50 AM
TMS Re: Reformat SSN to add... 01-17-2013, 12:33 PM
wkelley Re: Reformat SSN to add... 01-17-2013, 12:46 PM
TMS Re: Reformat SSN to add... 01-17-2013, 03:03 PM
TMS Re: Reformat SSN to add... 01-17-2013, 04:39 PM
  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Seattle Washington
    MS-Off Ver
    Excel 2003
    Posts
    40

    Reformat SSN to add dashes between numbers

    I have a list of 375 social security numbers. I want to reformat the numbers to add a dash in between the numbers so I can run a query on them. Right now they are showing as 123456789. I want them to show as 123-45-6789. Does anyone know of a fast and easy way to make this happen instead of me clicking in each cell and adding a dash between the numbers?
    Thanks.
    Last edited by wheatgrass; 06-13-2011 at 10:30 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1