How to Format Mobile Phone Numbers for Uploading
From EtelligentWiki
Due to the Issues Uploading Excel Spreadsheets and CSV Files, when uploading mobile phone numbers using either of these file types, we recommend that:
- The leading "0" (zero) is replaced by "44".
- Any spaces are removed.
Example:
With the mobile phone number 07123 456 789, you should:
- Remove the leading "0" and replace it with "44": 447123 456 789
- Remove any spaces: 447123456789
This should ensure that mobile numbers are imported correctly.
