• 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

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

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