HOW DO I REMOVE HYPHENS IN SOCIAL SECURITY NUMBERS IN A COLUMN IN EXCEL?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AUNTCEE@officeformac.com - 22 Jul 2008 19:10 GMT

Version: 2008

HOW DO I REMOVE HYPHENS IN SOCIAL SECURITY NUMBERS IN A COLUMN IN EXCEL?

Reply to this Message

Bob Greenblatt - 22 Jul 2008 20:42 GMT

On 7/22/08 2:10 PM, in article 59b54d93.-1@webcrossing.caR9absDaxw,

> Version: 2008
>
> HOW DO I REMOVE HYPHENS IN SOCIAL SECURITY NUMBERS IN A COLUMN IN EXCEL?

Please don't SHOUT by using all caps. Try Edit-Replace. Type a hyphen in the
find box and nothing in the second box. You may have to reformat the result
to show leading zeros. Try the custom format "000-00-0000" to display the
number with the hyphens.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

CyberTaz - 22 Jul 2008 21:23 GMT

... Or it could be that the cells are already formatted as Format> Cells>
Custom - Social Security Number, in which case it's a matter of applying a
different format, such as Text or General.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 7/22/08 2:10 PM, in article 59b54d93.-1@webcrossing.caR9absDaxw,

> Version: 2008
>
> HOW DO I REMOVE HYPHENS IN SOCIAL SECURITY NUMBERS IN A COLUMN IN EXCEL?

Reply to this Message

AUNTCEE@officeformac.com - 23 Jul 2008 20:37 GMT

> On 7/22/08 2:10 PM, in article 59b54d93.-1@webcrossing.caR9absDaxw,
> "AUNTCEE@officeformac.com" wrote:
[quoted text clipped - 10 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Reply to this Message

AUNTCEE@officeformac.com - 23 Jul 2008 20:40 GMT

I tried it, but it didn't work. I tried the second person's suggestion and that didn't work either. I could get rid of the hyphens, but not the space the hyphen had occupied. I finally decided to attack the spreadsheet a different way, leaving out the SS#s entirely. It was accepted by the State Dept., so all is good again.

Reply to this Message

Bob Greenblatt - 23 Jul 2008 21:27 GMT

On 7/23/08 3:40 PM, in article 59b54d93.3@webcrossing.caR9absDaxw,

> I tried it, but it didn't work. I tried the second person's suggestion and
> that didn't work either. I could get rid of the hyphens, but not the space the
> hyphen had occupied. I finally decided to attack the spreadsheet a different
> way, leaving out the SS#s entirely. It was accepted by the State Dept., so all
> is good again.

Well, if you tried it and it didn't work, you did not follow my directions
properly; it works fine. But, I'm glad you got the result you needed.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / July 2008

HOW DO I REMOVE HYPHENS IN SOCIAL SECURITY NUMBERS IN A COLUMN IN EXCEL?