+ Reply to Thread
Results 1 to 8 of 8

How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphone

  1. #1
    Registered User
    Join Date
    01-29-2011
    Location
    Upland, California
    MS-Off Ver
    Office 365
    Posts
    32

    How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphone

    I have Excel spreadsheets with prospect info, inclusive of their phone numbers, that I would like to be able to dial by clicking on the phone number when I have opened the spreadsheet on my IPhone. I am accessing the spreadsheet through Microsoft OneDrive on my IPhone. Multiple rows of data. One Prospect per row. All phone numbers reside in the same column.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    Found this as a possible solution

    http://forums.whirlpool.net.au/archive/2066369

    tested on my iPhone and it works for me.

    Saved numbers in this format xxx-xxx-xxxx
    Last edited by alansidman; 04-30-2016 at 03:29 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    I can't find reference to dialing a phone number from Excel.

    The only way that I know of is to import the numbers into a contact list that supports telephone calling. If you can import the Excel listing of telephone numbers and contacts then you should be able to call using the iPhone. I don't have an IPhone so can't test it.
    This may help you https://www.youtube.com/watch?v=d8gPv7B6g3k
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    01-29-2011
    Location
    Upland, California
    MS-Off Ver
    Office 365
    Posts
    32

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    Thank you Alan! I did come across that post earlier. While it did work, making the phone numbers clickable, most of my prospect data was all jumbled up. Will try again though.

  5. #5
    Registered User
    Join Date
    01-29-2011
    Location
    Upland, California
    MS-Off Ver
    Office 365
    Posts
    32

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    Thanks Newdoverman. That youtube video was not what I was looking for.

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    I think this one will help to make calls from spreadsheet

    https://www.youtube.com/watch?v=O7tbpq4SavE
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  7. #7
    Registered User
    Join Date
    01-29-2011
    Location
    Upland, California
    MS-Off Ver
    Office 365
    Posts
    32

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    Thank you Alkey. Trying to get it to work. Will update you soon.

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to make Excel phone numbers clickable/dialed when spreadsheet is accessed on iphon

    I installed and tried the Skype Click to Call and it does work somewhat like the video. I created a file with a real telephone number and with the Click to Call, every number, even local, was going to be a toll call which I found to be rather disappointing.

    I have found this that indicates that the iPhone can call a telephone number found on a web page. The web page can be produced the same way that is outlined in the video suggested by AlKey. The question comes down to whether or not the iPhone app will recognize the telephone numbers or if some coding has to be done to the number to make it recognizable.

    Here is the link that I found http://https://developer.apple.com/l...honeLinks.html

    Here is another that gives more detail on the construction of the telephone numbers
    http://http://code.tutsplus.com/tuto...s--mobile-7667

    This seems to be more of a HTML programming thing so that the iPhone will recognize the number.

    The Skype idea doesn't have the same restrictions on how the numbers are entered but one would have to investigate the cost of the calls as they are not free unless coded to be free.
    Last edited by newdoverman; 04-30-2016 at 06:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Clickable Phone Number on iPhone
    By Adam Schaefer in forum Excel General
    Replies: 3
    Last Post: 10-16-2014, 04:03 PM
  2. Is it possible to make Excel dial a phone number from my smart phone?
    By D_Step in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2013, 06:11 PM
  3. Format cell to be a clickable link when workbook is opened on iphone
    By CW2013-work in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2013, 07:10 PM
  4. Convert multiple email and phone numbers into clickable links for mobile Devices
    By kimcole5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2013, 04:58 AM
  5. [SOLVED] Is there a way to make Excel 2000 dial phone numbers?
    By TimeKeeper in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-02-2012, 01:59 PM
  6. [SOLVED] How do you remove duplicate phone numbers in an Excel spreadsheet
    By Bridgette in forum Excel General
    Replies: 1
    Last Post: 05-25-2006, 03:45 PM
  7. Replies: 0
    Last Post: 08-23-2005, 04:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1