• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

format to Social Security Numbers in Excel doesn't work for some cells

B

bluesky63

Member
Hi Excel Gurus,

In other forum there were a case of column who format as special > Social Security Numbers, it actually works for Cell A2 - A5498, however not from A5499 onwards, what is the issue ? what is the best way to fix it to make A5499 onwards same as the rest so that sorting of entire column can be done

Thank you very much
 

Attachments

  • SSN_issue.xlsx
    86.5 KB · Views: 2
Hi ,

The numbers which are getting sorted , have been entered as numbers , 9-digit numbers , and it is their formatting which is displaying the hyphens.

The numbers which are not getting sorted , have been entered as text , with the hyphens.

Remove the added hyphens and you will be able to sort the entire table.

Narayan
 

Attachments

  • Chandoo 3.xlsx
    84.9 KB · Views: 1
Hi Narayan
Cool, didn't know just use Ctrl H, replace "-" with blank for A5499 downwards
something it is that simple that we tend to use other formula, cut and paste back etc.

Thank you for your quick tip
Have a nice day
 
You must log in or register to reply here.
Back
Top