Mobility Site - View Single Post

Stu Mitchell · 01-25-06, 08:02 AM

Hi,

I want to view dates from an imported Excel file, but I can only see dates in US format (M/D/Y) - and I'd like them in European format (D/M/Y).

My regional settings are set for local (UK) - does anyone know if I can change excel (or my worksheet) to display all dates in D/M/Y?

Thanks,
Stu

01-25-06, 08:02 AM	#1 (permalink)
Stu Mitchell Aximsite Prospect Join Date: Jan 2006 Posts: 10 Thanked 0 Times in 0 Posts	Dates in Excel Hi, I want to view dates from an imported Excel file, but I can only see dates in US format (M/D/Y) - and I'd like them in European format (D/M/Y). My regional settings are set for local (UK) - does anyone know if I can change excel (or my worksheet) to display all dates in D/M/Y? Thanks, Stu