Computer was set up correctly ie. dd\mmm\yyyy.

However a previous step I took now appears to be working. I went to Excel, format, custom and typed in dd/mm/yy and chose that. Now I know its appears to be the same as the available date formats BUT its working... Login to read more.