Hello

My PC is set up as UK region and hence displays dates as 20/01/06. However
I have a spreadsheet sent from the US formatted as general and reflects
01/20/06 as the date. I am trying to use a vlookup where the dates match, I
have tried format cells, date dd-mm-yy but this does not work it still shows
01/20/06.

I have also tried to use datevalue, day, month, year functions (as a serial
number) and then looking up those values. However they all return #value.
Does anyone have any ideas how I can convert this date to UK date format?

Any help is appreciated.

Thanks.