Add 0 to Mobile Numbers in Excel Follow

Oh no! The zero fell off your number!

To add the zero back into your mobile numbers, when you export your data from the system to Excel is easy!  Just follow these steps :

  1. Open your data in Excel (or similar product).
  2. Highlight the column of mobile numbers.
  3. Right click the column and choose the option 'Format Cells'.
  4. Go to the 'Custom' option from the left.
  5. In the 'Type' text box, type in 10 zeros (0000000000).
  6. Click 'Ok' and then save your data.
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request