RE: Show alternate or different characters
- From: "Jason Morin" <jasonjmorin@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 09:39:25 -0700
Try using a formula in the adjacent column and then hiding the original
column. Assuming the SSN are in col. A:
="XXX-XX-"&RIGHT(A1,4)
HTH
Jason
Atlanta, GA
"Greg Hill" wrote:
> I have a column that contains Social Security numbers. I would like this
> column to display the numbers as 'xxx-xx-1234'. I can't seem to be able to
> figure out how to do this. Cell formatting doesn't tell really say about a
> 'replacement' character.
.
- References:
- Show alternate or different characters
- From: Greg Hill
- Show alternate or different characters
- Prev by Date: RE: How can I search for words in all caps in Excel?
- Next by Date: strip minus signs from right to left
- Previous by thread: Re: Show alternate or different characters
- Next by thread: How do I add/subtract hours and minutes when some values exceed 2.
- Index(es):
Relevant Pages
|
Loading
