Australia Date Format Not Working

Hello,
I have followed the instructions that are meant to update dates into Australia format from here:

But this is not working. Is there something I am missing?

Details:

Set the locale in the google sheets:

Manually update the format of all date columns in the google sheet by going format _> number → date/time

Verified the data loclate is coming through correctly in Apphseet:

Updated google chrome browser language settings:

Dates are still appearing in the incorrect format: