Aug 07 2019 12:12 PM
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 -
Aug 07 2019 12:44 PM
Aug 09 2019 04:28 AM
Aug 09 2019 08:05 AM
Aug 09 2019 09:25 AM
Aug 09 2019 09:43 AM
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