Change number format
 

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

Change number format
 

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
---------------
Jacob Skaria


"da" wrote:

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

Change number format
 

It looks like you're trying to hide the digits? Could use something like:

="xx-xxx-"&RIGHT(A2,4)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"da" wrote:

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

Change number format
 

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"da" wrote:

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

Change number format
 

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
---------------
Jacob Skaria


"da" wrote:

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"da" wrote:

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

Change number format
 

Does this work for you
="xx-xxx-"&RIGHT(A1,4)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"da" wrote in message
...
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