Feb 12 2021 10:25 PM
Calling Australian numbers to Australian numbers
Landline numbers are recognised in the Autodialer (Anaudi Premium) without the zero eg. 363303717. That works! and rings! in the Autodialer. That works fine over all.
However 0363303717 (is the correct number) and ofcourse the "0" can't be displayed and I can't get it to work in any format type. See below, in the mobile phone numbers for the different variations I have tried.
The problem is calling Australian mobile phone numbers. 0478145554 is the correct number, however in all the formats I have tried it doesn't work in the Autodialer.
-I've tried 478145554, that doesn't work. Autodialer doesn't recognise it.
-I've tried "Format Cells", "Custom", "0000000000" ie "0478145554". That doesn't work. Autodialer doesn't recognise it.
-I've tried "Format Cells", "Text". That doesn't work. Autodialer doesn't recognise it.
-I've tried "Format Cells", "Text". (I don't know about editing the "flag" features)
Autodialer (Anaudi Premium) comes with a 3 day free trial, if you want to test and trial it.
I hope you can help solve this problem please as I can't find any support from Autodialer (Anaudi Premium) or any other autodialer product.
Feb 12 2021 11:47 PM
Either format the cells as Text, then add the leading zeros, or prefix the values with an apostrophe and add the leading zeros.
Feb 13 2021 12:39 AM
Hi @Patrick_Gibson ,
What I'd like to offer you is to format your numbers as "Phone Number".
Format Cells - Special - Phone Numbers.
Please next photo and attached excel file.
I hope it will help.
Feb 13 2021 05:23 AM
I have spent 12hours on it. I can't work it out.
I've tried. And nothing works for calling a mobile phone number.
Doesn't allow, ()-' & space. It mentions that, one of few instructions
Tried '0478148945, text +614781489945, (04)78148945, 0478-148-945
61478148945 (number appears on the graphic user interface, tries to ring but doesn't connect)
=text(b1,"0000000000")
I removed the Green Flag.
Postcode, numbers, text, phone number, general
Custom, Type: 0000000000
Text 0478148945 and '0478148945 (The green flag or formula is blocking it) only the "0" appears on the graphic user interface.
Xls and xlsx , files, I'm thinking are the other brands of these file type and NOT Microsoft Excel.
Feb 13 2021 05:38 AM
Maybe my Mircosoft Excel is not the Australian version: Eg Format Cells, Special, Phone Number. It will not allow me to put a "0" into it. (43)355-2353.
Feb 13 2021 06:54 AM
If formatting the cell as Text and entering 0478145554 doesn't work, I have no solution for you...
Feb 13 2021 10:26 AM
As a comment, you can't change any value with formatting only. Format only could change the way how the value is presented to the user (e.g. 123 as 0123; 44240 as 13 Feb 2021; etc).
Thus the only option is what @Hans Vogelaar suggested (text).
Why autodialer doesn't work with texts and does it have an option to add leading zero to some area codes - that's the question to authors of autodialer.