📖 Bulk SMS End User Guide
Fix Excel E+11 Number Format
Fix Excel E+11 Number Format
📋 When does this happen? When you open a CSV file in Excel, phone numbers starting with 60 may display as scientific notation (e.g. 6.01234E+11). Follow these steps to convert them back to the correct format.
1
Open the CSV file in Microsoft Excel. When the Text Import Wizard appears, tick "Comma" as the delimiter and click "Next".
2
Select the column showing E+11 numbers. Right-click and choose "Format Cells".
3
In Format Cells, select the Number category with 0 decimal places as shown. Click OK.
4
The phone numbers will now display correctly. Save the file as CSV again before uploading to iSMS.
📞 Need Help?
Email: sales@mobiweb.com.my (include your username) |
Toll Free: +6016 450 2380 |
KL: +6016 450 2380
FREE Download (PDF)
Guide Details
Download: Free
Version: 1.2
Size: 2.65 MB
Language: English
Requires: PDF Viewer
© 2026 Bulk SMS Singapore · Powered by iSMS Malaysia · MobiWeb Sdn Bhd
Version: 1.2
Size: 2.65 MB
Language: English
Requires: PDF Viewer
© 2026 Bulk SMS Singapore · Powered by iSMS Malaysia · MobiWeb Sdn Bhd