How do I change this from the US Phone number to a UK phone number

**umararif1** · 10-15-2014, 01:38 PM

This contains validation however I think it is only made for US phone numbers
UK phone number example:- 07954378145
07 Or +447 can be used as the beginning of the phone number

**mehmetcik** · 10-15-2014, 01:41 PM

Firstly may I ask that you edit your post and wrap your codes within code tags.

Select each macro in turn and click on the # symbol in the menu bar.

**umararif1** · 10-15-2014, 01:49 PM

Thanks, new to this forum, don't know how to use it yet.

**jolivanes** · 10-15-2014, 02:01 PM

Re: "don't know how to use it yet."
A start to that would be reading the Forum Rules (At the top)

**umararif1** · 10-15-2014, 02:03 PM

Thanks for your 'help'

**martindwilson** · 10-15-2014, 02:14 PM

before you start you need to define what you are trying to validate 071 074 075 076 077 078 079 are uk mobile prefixes
070 isnt and at present neither are 072,073,077,070

**umararif1** · 10-15-2014, 02:20 PM

079 only I will only be adding numbers with 079 prefixes

How do I change this from the US Phone number to a UK phone number

LinkBack

Thread Tools

Rate This Thread

Display

How do I change this from the US Phone number to a UK phone number

Re: How do I change this from the US Phone number to a UK phone number

Re: How do I change this from the US Phone number to a UK phone number

Re: How do I change this from the US Phone number to a UK phone number

Re: How do I change this from the US Phone number to a UK phone number

Re: How do I change this from the US Phone number to a UK phone number

Re: How do I change this from the US Phone number to a UK phone number

Thread Information

Users Browsing this Thread

Similar Threads

I need a VBS code that change a phone number to the name of the owner

Change Phone number format

Change phone number in bulk

Is it possible to make Excel dial a phone number from my smart phone?

Format change of phone number

Bookmarks

Bookmarks

Posting Permissions