You are right when changing  the Regional Settings to UK and see what it is.
However, when executing Format(Date, "Long Date") and place the resulting value
into a cell,
doesn't yield the proper result---it results in a date  serial# within the cell.
Try it and see.