Power Pivot Date Query

[gmazza76]

Good afternoon,

I have imported a file in to Power Pivot for interrogation, but I have found an issue.
When I have uploaded the file the date format has come through as "YYYY-MM-DD" as text and I cant work out how to change this to "DD/MM/YYYY" for the "lookupvalue" and other formuals.

Any ideas as I have tried a few different things, but when the format has completed it always shows as text

thanks
Gavin