1. Home
  2. Basic Questions
  3. How to Send Multiple WhatsApp Messages from Excel Sheet – How to Correctly Format the Numbers?

How to Send Multiple WhatsApp Messages from Excel Sheet – How to Correctly Format the Numbers?

Although using the excel sheet eases a lot of work but at the same time if you don’t format the numbers correctly in the CSV file, it will break and the file upload won’t work with WASender.

Example:

wrong format error
Any number with an ‘E’ will not work correctly in WASender

How to Correctly Format the Numbers Column

1️⃣ Select the numbers column -> Right Click -> Click on ‘Format Cells’.

click on format cells

2️⃣ Go to the ‘Number‘ category -> Go to the ‘Decimal Places‘ box.

number>decimal

3️⃣ Change it to ‘0’ and click ‘OK’.

set decimal from 2 to 0

4️⃣ Verify that the numbers are now showing correctly.

verify

5️⃣ Correctly save the file as ‘CSV.

save as csv
Updated on September 30, 2021

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment