Phone number formatting for Australia

gday team, having an issue here which is causing havoc between airtable and zapier.

so i’m trying to use zapier to search for a record and use look up fields to compete the table.

but in my input form from airtable the phone numbers come out like this:

Screen Shot 2020-09-08 at 10.39.15 am

and when they come back from ClickSend they look like this:

Screen Shot 2020-09-08 at 10.40.48 am
:face_with_symbols_over_mouth:

so i can use ‘numbers’ in zapier to format the phone number, but then it comes out like this:

Screen Shot 2020-09-08 at 10.41.13 am

note the bracket is different - (0401) compared to (040) which is the default formatting in airtable for phone numbers.

so this means that search won’t match these records even though they are the same

:face_with_symbols_over_mouth::face_with_symbols_over_mouth::face_with_symbols_over_mouth:

anyone know how I can solve? i need to format one of them, but can’t figure out how to do it…