This is really odd.
If we run a report and display it to the screen dates are correct dd/mm/yyyy. However if we then chose the option to download into excel the resulting column goes American mm/dd/yyyy.
I have checked the langauge settings on the report server and on the internet setting on the report server. Both being English Australia
Our developer has checked the date format on the report and it's correct.
Now to make it stranger. If our developer runs the report in visual studio and then downloads to excel the date formats remain correct.
Any ideas ? Anyone seen anything like this before ?