Forum Discussion
Excel "0" isn't recognised in the mobile numbers of a xls/.xslsx file for a telephone Autodialer
Either format the cells as Text, then add the leading zeros, or prefix the values with an apostrophe and add the leading zeros.
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.
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.
If formatting the cell as Text and entering 0478145554 doesn't work, I have no solution for you...
