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

Copper Contributor

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 -

5 Replies

Hello @abc12330,

 

Press Ctrl+1 and scroll down to date. What is your location set to?

@PReagan 

 

Location is set to English (United Kingdom).

@abc12330,

 

In this case I do not know the answer. Maybe @Sergei Baklan will have an answer for you?

@abc12330 

You may apply custom format like

clipboard_image_0.png

 

@abc12330 

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

clipboard_image_0.png