how to change format of date from mm dd yyyy to dd-mmm-yyyy in MS Excel

Question

I need to upload data onto a software from my excel sheet. however the format of is not changing from mm/dd/year (e.g 08/28/18) to dd-mmm-year (e.g 28-Aug-2018 or 28-Aug-18)

please assist.

Comments

15 /06/1997 please help me English meaning ddmm yyyy

Answer 1

First, pick the cells that contain dates, then right-click and select Format Cells. Select Custom in the Number Tab, then type 'dd-mmm-yyyy' in the Type text box, then click okay. It will format the dates you specify.

Comments

This is not a formula

---

The issue is the format not changing to 'dd-mmm-year'. I use MS Office 2007 and this format which is available under Locale : English (United Kingdom) works fine for me but the option 'dd-mm-yyyy' displays all dates below 10 (i.e., 1-9) as 'mm-dd-yyyy'. For eg., Under 'dd-mm-yyyy' (either Custom or Preset), if you type 14/01/2022 it displays as it is but if you type 09/01/2022 it will display 01/09/2022. When double clicking the cell the correct value still appears though. Any single digit date (under the number 10) causes the cells to display the month first.

Answer 2

this problem is occured due to windows date and reginal setting. go to the date and region setting in control panel and change setting from mm-dd-yy to dd-mm-yy. problem is solved.

Answer 3

i am using in angular its work 2018-Aug-28 this type  u can change particular format u wont

this.dob is ng model name used

 let birthDate = new Date(this.dob);

     this.dob = birthDate.toLocaleDateString('en-GB', {

       year: 'numeric', month: 'short', day: 'numeric'

     }).replace(/ /g, '-');

   

 console.log(this.dob)