Format for UK phone numbers

[ExcelFailure]

Morning,

Can anyone tell me how to set a format for UK phone numbers? So like (#####) ######

Thanks

[XOR LX]

Hi,

Format Cells/Number/Custom, enter this in the Type: box:

("0"####) ######

Regards

[ExcelFailure]

Great thanks - the 0 has disappeared too, can this be sorted?

[XOR LX]

Sorry - just amended previous post. Try now.

[ExcelFailure]

thanks

[XOR LX]

You're welcome.

[kevlee]

The UK has landlines in the format 01xxx xxxxxx and citys have 01xx xxx xxxx
Mobiles are always 07xxx xxxxxx

I have a corrupted csv from my iphone and the numbers are sometimes in the wrong format or the wrong column ie mobiles in home number and landlines in mobile number.

I have over 1000 contacts and I'm doing this manually.

There must be a better way???

TIA

[AliGW]

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread