How To Format Phone Numbers In Excel
Earlier today, I decided to send a bulk sms to over 5000 phone numbers at NairaForSMS. The numbers were in an excel file but not in the format supported by the bulk sms site. After copying the numbers from the excel sheet to a notepad, the numbers were displayed in the form of 2.34704E+12 instead of 2347000000000.
Without using any file conversion software, I was able to format the phone numbers in excel without decimals i.e I was able to make the numbers display as phone numbers.
If you've got some phone numbers you would like to format in similar way, just follow me through the steps below:
==> Select range of cells containing the phone numbers
==> Right Click on the selection
==> Click format cells option
==> Click the "Numbers" tab
==> Click "Custom" in the category list
==> Click "O" as the type as seen in the screenshot below:
==> Click OK.
The numbers in the selected range of cells should now display the phone numbers completely.
Recommended: How To Add First Zero to Nigerian Phone Numbers At Once With Excel
Click here to like our Facebook Page and here to join our Telegram Channel for more free unlimited Internet tricks and tutorials.
Without using any file conversion software, I was able to format the phone numbers in excel without decimals i.e I was able to make the numbers display as phone numbers.
If you've got some phone numbers you would like to format in similar way, just follow me through the steps below:
==> Select range of cells containing the phone numbers
==> Right Click on the selection
==> Click format cells option
==> Click the "Numbers" tab
==> Click "Custom" in the category list
==> Click "O" as the type as seen in the screenshot below:
==> Click OK.
The numbers in the selected range of cells should now display the phone numbers completely.
Recommended: How To Add First Zero to Nigerian Phone Numbers At Once With Excel
Click here to like our Facebook Page and here to join our Telegram Channel for more free unlimited Internet tricks and tutorials.
Warning ⚠
Azeeztech Blog and its contents are protected by COPYRIGHT LAW (DMCA) with high-priority response rate. Reproduction without permission or due credit link back will cause your article(s) to be removed from search engines and disappearance of Ads on that page if monetized with Adsense.
About Azeeztech
We provide solutions to your device (phones, laptops, tablets etc) related problems with Freenet and Mobile Stock Rom.
Newer Posts
Newer Posts
Older Posts
Older Posts
Comments