Convert US Date to UK date for Web Query

I import data from a website that has dates in the US format, but I would like to convert that to the UK format. Changing the cell format did not work.