Replace slash sign to dash sign

Hi friends,

Greetings from me!

In column there are phone numbers. The digits are not fixed. I want the user to use dash sign to separate country code, std code, area code and phone number with dash sign only. But sometimes some users uses slash sign to separate it which I don’t want. If the user used slash sign to separate it then I want to change the slash sign to dash sign automatically after hiding the enter key. The column is formatted as ‘Text’. In short I don’t want any other sign except dash sign to separate the digits.

Any help will be highly appreciated.

Thanking you in anticipation.

Hello mso3,

Place the Code below in a Standard Module;

Please Login or Register  to view this content.

Try the attachment.

Regards.

Hi Winon,
Perfect! Thank you. Can we make it automatic b inserting the code in sheet module? So that after entering the phone number after changing the cell the slash will be automatically change to dash. If not possible then leave it; I will mark the thread solved.

Thank you and have a nice time.

Thank you for the feedback mso3,

Delete all the Code and Buttons from my sample attachment, then in the relevant Sheet enter the Code below:

Please Login or Register  to view this content.

Enjoy!

Regards.

Hi Winon,

Thank you for taking trouble for me. It's not working as per requirement. Please see the attached workbook and suggest me where I'm wrong.

Thanking you.

Hi mso3,

JOHN H. DAVIS was faster than me! Gonna kill him for that!LOL

You may delete the Calculation Code and only use what he has added. So you will only be using the Code below!

Please Login or Register  to view this content.

@JOHN H. DAVIS,

Stop Hi-Jacking my Threads!

Thank you for you helping out here!

Regards.

Hi Winon.

Please don't be angry. We all are friends helping each other.

Thank you. Now it's working fine.

Hi John,
Thank you. It's working fine.

I appreciate you both for your kind assistance to solve my problem.

Thank you and have a nice time.

Hi mso3,

Please don't be angry.

I am 100% certain that JOHN H. DAVIS is not offended, and he knows that I was only jerking his chain!

Adding a bit of humor lighten things up a bit, don't you think?

You are welcome, glad we could help you, and thank you for the REP!

Regards.