How to correct phone number format in CSV
Use Case: To ensure CSV can be uploaded successfully with the correct phone number format.
Click on the drop down arrow on column B to select the whole column.
Right click on Column B, then click on “Number Format”.
Step 3 Choose “Number” in the category, the adjust the Decimal place into “0”.