I have generated an Excel spreadsheet from a report, in which before export, the date is formatted and displayed in UK format (dd/mm/yyyy).

Once it has been exported, and is opened in Excel though, the cells display the US format.

I have changed all my settings to UK format on my computer, and can report similar behaviour in the UK on an English(UK) install.

The odd behaviour here is that if I highlight a cell, the formula cell displays the correct UK formatted date as shown in the screen capture.

http://www.lucidcorals.com/excel_issue.jpg

Any ideas here?