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:

excel format numbers

==> Click OK.

The numbers in the selected range of cells should now display the phone numbers completely.

RecommendedHow To Add First Zero to Nigerian Phone Numbers At Once With Excel

Please Share :

See also :   How To Copy WorkSheet From Excel Workbook File To Another

Written by Jide Ogunsanya

Pro Nigerian Blogger, Digital Marketer and Web designer. I help business owners to grow their businesses online. You can join my Facebook Group here.


Leave a Reply

Leave a Reply

We're glad you have chosen to leave a comment. Please keep in mind that comments are moderated according to our comment policy. Your email address is required but will not be published. No keyword stuffing in the name field and commenting from blah blah blah makes no sense. Thank You.

  • Millionaire Reveals How You Can Make Millions Doing What You LoveRead More
  • Free Ebook Explains How To Design WebsiteDownload Now
  • We can help you ship items from Amazon USA to NigeriaMore Info
  • Do you want to ask some questions?Click To Ask

God Saved Me

Adsense Product Recap 2014