How to correct phone number format in CSV

Use Case: To ensure CSV can be uploaded successfully with the correct phone number format.

Step 1

Click on the drop down arrow on column B to select the whole column.

Step 2

Right click on Column B, then click on “Number Format”.

Step 3 Choose “Number” in the category, the adjust the Decimal place into “0”.