Date format in Excel 2010

**omaoma** · 11-17-2013, 04:17 PM

Hello,

I have to put a date in dd/mm/yyyy format in a workbook (Excel 2010), regardless of the date format in Regional settings.
In the format menu everything is ok ( I'm using the dd/mm/yyyy format), but the date is displayed according to the format n Regional settings ( mm/dd/yyyy).
Thank you for your help,
Mirela

**6StringJazzer** · 11-17-2013, 09:43 PM

If you are using a Custom Format and specifying dd/mm/yyyy then that should override the default setting. Please attach your file if you can.

**omaoma** · 11-22-2013, 08:09 AM

Hello.Thank for your quick answer. And Yes, I'm using the Custom format and still doesn't work . I the meantime I have changed the Regional settings for all the computers where I had to put the file, and it is ok.
And thank you again,
Mirela