Skip to content
new ogbongeblog logo
  • Advertise
  • Blog
  • Contact

How To Format Phone Numbers In Excel

  1. Home
  2. Blog
  3. Uncategorized
  4. How To Format Phone Numbers In Excel
December 19, 2014

Written by

jidetheblogger Avatar
jidetheblogger

Last Modified :

October 8, 2017

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.

phone numbers excel format

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.

Recommended :  How To Add First Zero to Nigerian Phone Numbers At Once With Excel

Please Share :
excel tips

Like What You Read?

Sign Up to get similar articles delivered to your email inbox.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

4 responses to “How To Format Phone Numbers In Excel”

  1. Don Martins Avatar
    Don Martins
    December 19, 2014

    Another successful discovery by the ogbonge master. BTW Jide wetin u wan send to with 5k phone numbers? http://www.nairawriter.com

    Loading…
    Reply
    1. Jide Oguns Avatar
      Jide Oguns
      December 19, 2014

      Advert things bro…lol 🙂

      Loading…
      Reply
  2. Anonymous Avatar
    Anonymous
    December 19, 2014

    Nice one boss

    Loading…
    Reply
    1. Jide Oguns Avatar
      Jide Oguns
      December 19, 2014

      Thanks

      Loading…
      Reply

WANT TO ADVERTISE?

Chat on WhatsApp

RELATED POSTS

  • Convert XLS : Free Software That Converts XLSB File To XLS
  • How Do I Text From Computer To Cell Phone?
  • How To Send BulkSMS/ CustomizeSMS

FEATURED


  • How to Pay Chinese Suppliers in RMB (Alipay & WeChat Pay) or Swap Naira, Kenyan Shillings, Ghana Cedis & USDT in Minutes

    How to Pay Chinese Suppliers in RMB (Alipay & WeChat Pay) or Swap Naira, Kenyan Shillings, Ghana Cedis & USDT in Minutes

JOIN AI WEB DESIGN GROUP


  • AI Website Design Training Whatsapp Group by Jidetheblogger

    AI Website Design Training Whatsapp Group by Jidetheblogger

RANDOM POSTS


    I Got One Free Month of Meta Verified After I Tried to Cancel My Subscription


    How To Make Money On Bamboo App: 5 Proven Ways


    How To Use Vibe Coding To Make Money


    How I Earn $100 Per Referral from Affiliate Marketing


    Bluetooth Printer That Connects To Phone


    Can I Use OPay Card for Facebook Ads?


    Why I Moved My Websites From Namecheap To Interserver.net


    How I Earn $50 Per Sale


MORE RANDOM POSTS
← God Saved Me
Adsense Product Recap 2014 →

Join 25,000+ subscribers

Receive our latest blog posts in your inbox.

Search

Social

Facebook

Instagram

Twitter

new ogbongeblog logo

Copyright © 2026 | About | Advertise | Featured | Sitemap | Privacy Policy | Powered by WordPress

Your cart (items: 0)

Products in cart

Product
Details
Total
Subtotal ₦0.00
Shipping and discounts calculated at checkout.
View cart
Go to checkout

Your shopping cart is empty

Return to shop

Notifications

%d

    LIKE My Fan Page

    Privacy Policy | Copyright © 2012,OgbongeBlog.All Rights Reserved. Powered by Blogger .
    Create a Mobile Site
    View Site in Mobile | Classic
    Share by: