UK WhatsApp Full-Format Screening Tutorial

Let’s start with the conclusion

UK mobile numbers are written locally07The first 11 digits are the first number, for example07700 900123。 When used for international business, the lead must be removed0, writing+44 7700 900123。 During data cleaning, uniformly convert to the E.164 standard format:+447700900123（+44followed by a 10-digit number, excluding spaces, parentheses, and lines)。 One sentence to remember the complete cleaning rules: remove symbols →0044Exchange+44→ Removed+44The ones behind it0→ Verify length.

---

How many digits are there in UK phone numbers?

UK mobile numbers consist of three parts:

Composition	Explanation	Example (local format)
Preface 0	The UK domestic long-distance access code must be removed when making international calls	0
Mobile network segment	Usually7Network numbering, for example77、75、74	7700
User number	The network assigns users 6-7 digits of their numbers	900123

The local format is079 digits = 11 digits, for example:

• 07123 456789(Reserved film and television number segments by Ofcom)
• 07700 900123(Reserved film and television number segments by Ofcom)

The international format is:+4410 digits = 13 characters (including+number), for example:

• +44 7123 456789
• +44 7700 900123

Be careful not to confuse UK landlines with mobile phones when judging:

• Mobile:07Opening with 11 people, national unity
• Landline:01Or02Initials, with variable digit counts (9 or 10 digits), such as London020 7946 0958

If you have it in your form07If the number starts with a 11-digit length and is not 11 digits, the data itself is problematic and should be marked as abnormal during cleaning.

---

How to switch between local and international formats: 44, 00, pre-order 0

When is Pre-Zero retained?

UK domestic dialing:07700 900123, must be preserved0。
International Dialing:+44 7700 900123, it must be removed0。

+44Later, it appeared0It’s an incorrect spelling, for example+44 07700 900123If it cannot be used directly, it should be automatically corrected during cleaning+447700900123。

+and was known as He00The relationship

+It is the universal symbol for the International Access Code,00It is a common European international long-distance prefix (used when dialing international numbers from UK landlines).

Therefore, the following usage methods have the same meaning, but must be unified when storing:

Original writing	Meaning	Standardized results
07700 900123	Local format	+447700900123
+44 7700 900123	International format	+447700900123
0044 7700 900123	International prefix format	+447700900123
+44 (0) 7700 900123	Writing style (including traps).(0)）	+447700900123

A common pitfall:+44 (0) 7700 900123

Some British companies and business cards like to write about it+44 (0) 7700 900123, which means “within the UK.”07700..., and is allocated abroad+44 7700...“。 Inside the parentheses0Not the actual number content,It must be deleted during cleaning, otherwise after joining, it becomes+4407700900123, with one more person added.

The table below shows quick conversion lookups:

Scene	Dialing method	Number Writing Method
Call within the UK	Direct dial0The beginning	07700 900123
Calling the UK from China	Use+Or00	+44 7700 900123Or0044 7700 900123
Unified storage in the database	Only use E.164	+447700900123

---

Spaces, parentheses, blanks: Why is it recommended to delete them all?

The following common ways UK numbers are used in business cards, websites, and email signatures:

• 07700 900123
• +44 7700 900123
• +44 (0) 7700 900123
• +44-7700-900123

These separators serve only to read beautifully,It doesn’t mean anything to the numbers themselves。 Different systems have inconsistent rules for parsing delimiters: some systems use+44-7700...treat it as area code, and some APIs will directly give errors.

Cleaning rules:

1. First, delete all spaces and tab stops
2. Then delete-、(、)、.Equal separator
3. Only the numbers and the beginnings are kept+

This way, you get a pure, comparable, and transferable number.

---

How to restore the scientific notation method in “E 11” in Excel to a phone number?

This is the most common Excel problem when cleaning numbers: a string07700 900123After entering it into Excel, it becomes7.70009E+09and even a prelude0Disappear directly, become one7700900123。

Principle

• Excel does not keep the number lead0，07700900123It will be converted into numbers7700900123
• Numbers exceeding one digit will be displayed as scientific notation by default (commonly referred to in the industry as “E display problems”)
• Users generally do not see thisE+11These few words, but rather,7.70E+09、+44Swallowed up, and so on

Repair methods

Method 1: Set the text format before importing

After creating a new Excel file, first select the entire column→ right-click “Format Cells” → “Text,” then paste the numbers into the file to prep0It won’t be lost.

Method 2: Declare column types when importing CSV

When opening CSV in Excel, select “Data → from Text/CSV” and specify the number column in the import wizard asTextInstead of thatGeneral。

Method 3: If it has already become scientific notation

Reduce it using a formula (assuming data is in A1):

=TEXT(A1, "00000000000")

If the number has already changed+44..., then you need to first put it in+Restoration:

=REPLACE(TEXT(A1, "00000000000"), 1, 1, "0")

This is just a sample formula. In practice, you need to choose the batch processing method based on your data volume or use the number processing tool directly.

Three habits to prevent losing them again

Operating habits	Explanation
The number column always saves the text	Do not save numbers in a “regular” format
Check the column format before exporting to CSV	Export in ‘text’ format to avoid automatic conversion
Database import uses character fields	Mobile phone number is used for entryVARCHARInstead of thatINT

---

Common errors in country codes and spelling errors

Mistake 1:+44There’s one more at the back0

Link	Data	After correction
Raw data	+44 07700 900123	+447700900123
System splicing error	country_codeYes+44，local_numberYes07700900123, merged into+4407700900123	Removed+44Closely following behind0 → +447700900123

When merging fields, never use country codes and prefixes0The “international format numbers” are directly spelled together.

Mistake 2:0044As part of the national code

00447700900123It looks long, so when washing, it’s a bit much0044Replace with+44That’s it:

• 00447700900123 → +447700900123

Mistake 3: There is a country code but+The number was lost

When exporting some systems+Swallowed up, becoming447700900123。

• Relying solely on the bare numbers447700900123, which may refer to the British name, or it may be used by other countries44The numbers at the beginning
• If the data source clearly shows UK operations, it can be supplemented+
• If the data source is unclear, this format should be marked as “Pending Confirmation” and not auto-complete

Mistake 4: Confusion between number and user nationality

Many business forms have both “Customer Nationality” and “Number” columns at the same time. During cleaningYou can only determine the country code by the number itself, you can’t just fill in China just because the client’s nationality is filled in+447700900123Forcibly changed to a Chinese area code. The country assigned the number should use the country code.

Mistake 5: Incorrectly adding the area code of another country

For example, incorrectly combining 07700 900123 with another country code:

• +86 7700 900123(Incorrect, China area code, UK number)
• +45 7700 900123(Incorrect, Danish area code)

This error is common when merging data across multiple layers. Handling method:First, remove all suspected country codes, then identify the local number structure。 The local structure of UK mobile numbers is:079 bits, identified0770If the beginning and the remaining part is 9 digits, it can be standardized according to UK rules.

---

Duplicate Number: Identifying the same number under different spellings

The following entries appear “different” in the database:

Traveling number	Raw data	Problem
1	07700 900123	Local format
2	+44 7700 900123	International format with spaces
3	+44(0)7700 900123	Included(0)Writing style
4	0044 7700 900123	00International prefix
5	7700 900123	Country code and spaces are missing

If spaces are not removed and the country code is not unified, these five lines will be treated as five different numbers, and deduplication will become invalid.

After normalizing all of them, the result is the same value:

+447700900123

So the correct deduplication order is:Standardize first, then reduce duplication。 Do not deduplicate the original column directly.

---

UK Mobile Number Standardization Process (7 Steps)

The following processes can be directly used in scripts, Excel formulas, or number processing tools:

Step 1: Clean the characters
Delete spaces, tab stops, line breaks,-、(、)、.and other non-numeric symbols, only retained+And the numbers.

Step 2: Unified international access code
Handle00The beginning0044...Replace with+44...。

Step 3: Complete the country code for the local number
With07Numbers starting with 11 digits are added at the front+44And remove the lead0。
For example07700900123 → +447700900123。

Step 4: Clear the prelude after the national code0
+4407...Or+44 0...All will be deleted+44Closely following behind0。

Step 5: Length verification
After standardization, the following must be met:

• With+44The beginning
• +44Exactly 10 digits after it
• Ten digits or more7Beginning (UK mobile number)

Flags that do not meet the criteria are marked as abnormal and should not be directly added to marketing tasks.

Step 6: Repeat the inspection
Standardized E.164 numbers are deduplicated, retaining unique records.

Step 7: Compliance check
Only handle data you legally hold and have access to. Do not batch access without authorization.

---

A complete Before / After sample table

Raw Data (Before)	Scenes appear	After Standardization
07700 900123	Excel local number	+447700900123
07700900123	No spaces in CSV	+447700900123
+44 7700 900123	Business card format	+447700900123
+44 (0) 7700 900123	British script	+447700900123
00447700900123	International prefix format	+447700900123
447700900123	Lost+	+447700900123(When the context clearly indicates the British number)
+4407700900123	Misalignment	+447700900123
Excel Scientific Notation cells	Digital format pollution	You must first restore the text to the original07700900123, then turn again+447700900123
+45 7700 900123	The country code was mistakenly labeled as Denmark	If the number segment belongs to the United Kingdom, it is corrected to+447700900123

The numbers in the table above all use the number segments reserved by Ofcom for film and television works, for format explanation only.

---

Batch cleaning: When should you use the tools?

Manually handling dozens of lines of numbers is no problem; But when you have thousands or tens of thousands of lines mixed with all the error types in Excel, manual cleaning is neither practical nor easy to miss.

If you also need batch standardized UK numbers and online number status checks, AppShai can provide a more complete processing chain: number standardization→ deduplication→ multi-dimensional filtering, directly outputting cleaned and verified number lists to prevent structural errors from escalating in subsequent business processes.

If you are dealing with global business data, you can also refer to the number formats and cleaning guidelines of other countries within the site to unify different country numbers into a single E.164 standard, then proceed to the downstream screening process.

---

UK Mobile Number Frequently Asked Questions (FAQ)

1. How many digits are there in the UK mobile phone number?

Local format 11 bits, with07Introduction. International format+44The last 10 bits, totaling 13 characters (including:+）。

2. +44The ones behind it0Should we keep them?

No reservations.+44Only 10 digits can be followed after it,0It is a UK domestic long-distance relay symbol and is not part of international numbers.

3. Why some UK numbers are written+44 (0) 7700 900123？

This is the custom of the British script, in parentheses0He said, “Please dial when calling within the UK.”0“。 Remove the brackets and the inside when cleaning0。

4. 0044And+44What’s the difference?

There is no essential difference,00is the prefix for international long-distance flights,+This is a more general method for writing International Access Codes. It is recommended to standardize database storage as follows+44。

5. What should I do if I can’t see the full UK phone number in Excel?

Change the cell format to ‘text’. If it has already become scientific notation, use itTEXTFunctional fitting00000000000Format restore. A safer approach is to set the columns to text format before importing.

6. What is E.164?

The global telephone number standard format defined by the International Telecommunication Union (ITU-T):+Country code: Domestic number (remove the precedent).0）。 The E.164 format corresponding to UK mobile numbers is+447700900123, excluding spaces and parentheses.

---

AppShai （AppShai）It is a globally leading number ecosystem processing platform, deeply integratedGlobal mobile number range coverage, batch number generation, intelligent deduplication, and multi-dimensional comparisonand other core capabilities, providing coverage for global corporate and individual clients220 countries and regionsNumber Checking and verification services.
Currently, the system is compatible with the following mainstream social and business applications, including:
WhatsApp、LINE、Telegram、Viber、Zalo、Signal、Facebook、Messenger、Instagram、Microsoft、Binance、iMessageand more.
We will continue to develop and support more platforms, so stay tuned.

Platform features cover all-dimensional filtering scenarios, supportedEnable filtering, active filtering, interaction filtering, gender filtering, avatar filtering, age filtering, online status filtering, precise tag filtering, online duration filtering, power-on detection filtering, blank number filtering, mobile device model filteringand more, meeting a wide range of business needs from basic to in-depth levels.

We offerSelf-service screening model, agency operation screening model, refined tiered model, and customized solution model, flexibly adapting to different usage scenarios for individual developers, small and medium-sized teams, and large multinational corporations.

The core advantage lies inOne-stop integration of global mainstream application ecosystems, delivering real-time high-precision screening results, helping you significantly reduce customer acquisition costs and improve global digital operational efficiency.