Change number format

  • Thread starter Thread starter da
  • Start date Start date
D

da

hello
Is there a way to change the SS# in the following format from an existing
table of SS#?
99-999-9999
change to
xx-xxx-9999
Thanks
 
I am not sure is this what you are looking for. If not post more examples.

="XX-XXX"&MID(A1,FIND("-",A1,FIND("-",A1)+1),LEN(A1))

If this post helps click Yes
 
It looks like you're trying to hide the digits? Could use something like:

="xx-xxx-"&RIGHT(A2,4)
 
I am not sure I understand the formula. I tried it and I got an error #N/A.
Is there any other way, more simple formula?
You can use any numbers as long as they are in SS# format, e.g. 123-45-6789
Thank you
 
Type your number in A1
In B1 enter the below formula
="XX-XXX"&MID(A1,FIND("-",A1,FIND("-",A1)+1),LEN(A1))

If this post helps click Yes
 
Back
Top