logo

How To Correct Phone Number Format In Excel/Google Sheet

Before you start uploading your contacts in Wabot Plus, make sure the phone number format is correct as below.

1

Right-click on your mouse from the header to highlight the entire cell

Right-click on your mouse from the header to highlight the entire cell
2

After the entire cell has been highlighted, right click on your mouse. Then click on "Format Cells"

After the entire cell has been highlighted, right click on your mouse. Then click on "Format Cells"
3

Click on "Number" and change the decimal places to 0. After that, click "OK"

Click on "Number" and change the decimal places to 0. After that, click "OK"
4

Finally, you will get the correct phone number format, ready to be uploaded!

Finally, you will get the correct phone number format, ready to be uploaded!