Format numbers in a cell according to what they start with

I'm trying to force UK telephone numbers to display correctly. All are 11 digits, but there are 3-digit, 4-digit and 5-digit area codes, and this affects subsequent formatting. There are 3 main ways of displaying phone numbers:

• 020 **** ****
• 01** *** ****
• 01*** ******

I think it may be an IF statement that will do the trick, along the lines of (with apologies for lack of syntax):

{IF <CELL> starts "02", display format *** **** ****} OR {IF <CELL> starts "0121","0131","0141","0151" (etc), display format **** *** ****} OR {ELSE display format ***** ******}

Is this possible in Excel?

Thank you!

Thanks very much, Martin. I don't understand it (yet) but it works, which is the important thing.

I know the UK telephone number formats are complicated, but the ones on my list are all in one of those 3 categories.

This is a stupid question, I know, but I'm going to ask it anyway.

Does the formula have to be in a different cell from the one where the data is entered? (I'm sure the answer is yes, given "circular reference" message that appears if it's in the data entry cell.)

Thanks again for your helpful and speedy response.

Thanks, Martin, for all your help, and especially for your polite and helpful reply to my last question.