Excel "0" isn't recognised in the mobile numbers of a xls/.xslsx file for a telephone Autodialer

%3CLINGO-SUB%20id%3D%22lingo-sub-2131021%22%20slang%3D%22en-US%22%3EExcel%20%220%22%20isn't%20recognised%20in%20the%20mobile%20numbers%20of%20a%20xls%2F.xslsx%20file%20for%20a%20telephone%20Autodialer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131021%22%20slang%3D%22en-US%22%3E%3CP%3ECalling%20Australian%20numbers%20to%20Australian%20numbers%3CBR%20%2F%3ELandline%20numbers%20are%20recognised%20in%20the%20Autodialer%20(Anaudi%20Premium)%20without%20the%20zero%20eg.%20363303717.%20That%20works!%20and%20rings!%20in%20the%20Autodialer.%20That%20works%20fine%20over%20all.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%200363303717%20(is%20the%20correct%20number)%20and%20ofcourse%20the%20%220%22%20can't%20be%20displayed%20and%20I%20can't%20get%20it%20to%20work%20in%20any%20format%20type.%20See%20below%2C%20in%20the%20mobile%20phone%20numbers%20for%20the%20different%20variations%20I%20have%20tried.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20problem%20is%20calling%20Australian%20mobile%20phone%20numbers.%200478145554%20is%20the%20correct%20number%2C%20however%20in%20all%20the%20formats%20I%20have%20tried%20it%20doesn't%20work%20in%20the%20Autodialer.%3CBR%20%2F%3E-I've%20tried%20478145554%2C%20that%20doesn't%20work.%20Autodialer%20doesn't%20recognise%20it.%3CBR%20%2F%3E-I've%20tried%20%22Format%20Cells%22%2C%20%22Custom%22%2C%20%220000000000%22%20ie%20%220478145554%22.%20That%20doesn't%20work.%20Autodialer%20doesn't%20recognise%20it.%3CBR%20%2F%3E-I've%20tried%20%22Format%20Cells%22%2C%20%22Text%22.%20That%20doesn't%20work.%20Autodialer%20doesn't%20recognise%20it.%3CBR%20%2F%3E-I've%20tried%20%22Format%20Cells%22%2C%20%22Text%22.%20(I%20don't%20know%20about%20editing%20the%20%22flag%22%20features)%3CBR%20%2F%3E%3CBR%20%2F%3EAutodialer%20(Anaudi%20Premium)%20comes%20with%20a%203%20day%20free%20trial%2C%20if%20you%20want%20to%20test%20and%20trial%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20you%20can%20help%20solve%20this%20problem%20please%20as%20I%20can't%20find%20any%20support%20from%20Autodialer%20(Anaudi%20Premium)%20or%20any%20other%20autodialer%20product.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2131021%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131135%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20%220%22%20isn't%20recognised%20in%20the%20mobile%20numbers%20of%20a%20xls%2F.xslsx%20file%20for%20a%20telephone%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965560%22%20target%3D%22_blank%22%3E%40Patrick_Gibson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEither%20format%20the%20cells%20as%20Text%2C%20then%20add%20the%20leading%20zeros%2C%20or%20prefix%20the%20values%20with%20an%20apostrophe%20and%20add%20the%20leading%20zeros.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2131184%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20%220%22%20isn't%20recognised%20in%20the%20mobile%20numbers%20of%20a%20xls%2F.xslsx%20file%20for%20a%20telephone%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2131184%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965560%22%20target%3D%22_blank%22%3E%40Patrick_Gibson%3C%2FA%3E%26nbsp%3B%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20I'd%20like%20to%20offer%20you%20is%20to%20format%20your%20numbers%20as%20%22Phone%20Number%22.%3CBR%20%2F%3EFormat%20Cells%20-%20Special%20-%20Phone%20Numbers.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20next%20photo%20and%20attached%20excel%20file.%3C%2FP%3E%3CP%3EI%20hope%20it%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ilgar_Zarbaliyev_0-1613205552963.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F254678iF53BE451CF42CF4E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ilgar_Zarbaliyev_0-1613205552963.png%22%20alt%3D%22Ilgar_Zarbaliyev_0-1613205552963.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

6 Replies

@Patrick_Gibson 

Either format the cells as Text, then add the leading zeros, or prefix the values with an apostrophe and add the leading zeros.

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.

 

Ilgar_Zarbaliyev_0-1613205552963.png

 

@Hans Vogelaar 

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.

@Patrick_Gibson 

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.

@Patrick_Gibson 

If formatting the cell as Text and entering 0478145554 doesn't work, I have no solution for you...

@Patrick_Gibson 

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.