I have been sent a file with dates. Some of the dates are appearing in the incorrect format. One date shows 8/10/2010 when it should be 10/8/2010. When I look at format of cell it shows English UK.Other dates appearing correctly have just general format. The sender of the file(US subsidary) confirms it displays correctly on her side.Wondering if anyone can advise where the problem might arise from. Many Thanks