Cant set date to DD/MM/YYYY only DD-MM-YYYY available

Question

I need to set a date to date format DD/MM/YYYY (forward slash) but my Excel 2016 only shows this date format with a dash (-). If i format cells only date types with a dash are available. My online version shows a forward slash. How do I override or add new date format types? If i set this as custom or manually Excel always over rides and replaces the / with a -

preagan · Answer

Hello&nbsp;abc12330,&nbsp;Press Ctrl+1 and scroll down to date. What is your location set to?

abc12330 · Answer

PReagan&nbsp;&nbsp;Location is set to English (United Kingdom).

preagan · Answer

abc12330,&nbsp;In this case I do not know the answer. Maybe&nbsp;SergeiBaklan&nbsp;will have an answer for you?

sergeibaklan · Answer

abc12330&nbsp;
You may apply custom format like

&nbsp;

sergeibaklan · Answer

abc12330&nbsp;
And changing format for entire system you may Win+R, type control international, ok, Additional settings, Date tab, and here, if not available from drop-down list, type desired format and apply

&nbsp;

Forum Discussion

Cant set date to DD/MM/YYYY only DD-MM-YYYY available

5 Replies

Resources