ssn

I have a table with around 10,000 records. The records are medical claims, where an individual claimant may have many rows of different types of claims. The individuals are identified by their Social Security Number (ClaimantID). I've created a column, Claimant Alias, where I use the =RIGHT()...

I have a table with around 10,000 records. The records are medical claims, where an individual claimant may have many rows of different types of claims. The individuals are identified by their Social Security Number (ClaimantID). I've created a column, Claimant Alias, where I use the =RIGHT()...

Hi all so i have a problem with social security numbers that start with 0 (zero). My cell is formated special and social s number ex. 015-60-1158. When i use the find button it will not find ssn starting with 0, to find the ssn i'm looking for i have to key in without the zero. Is there a way...

Hi all I have a sheet with soc. S numbers and start with 0. How do format so excel will find the ssn starting with 0?

Hello Everyone, I'll let you know I'm in accounting. I don't know a significant amount about VB but i've done a few projects that have at least given me a bit to work with. I need help with 1 part of my current project. Every Quarter I receive dozens of spreadsheets that I need to analyze...

Hello all, and thanks for reading. I need to import a new spreadsheet (or simply its data) into an ongoing Excel project that I've been working on. The only identifying data on this new document are social security numbers (SSNs). They are hard-coded with hyphens, which I text-to-columns'ed...

I am having trouble formatting a column of SSN. I need them to be in the 123-45-6789 format. I have tried special formatting, custom formatting, and neither are working. I am using office 2007 but think the file sent to me is excel 2003 if this makes a difference. Any help or advice is...