how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel [closed]

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.

3 Answers

Select the cell(s) you need to format.
- Then click on the small pop out icon in the Number section (circled in the image)
- This will open up the dialog box as shown
- Click on Custom
- In the Type: select from one of the standard ones or create your own. (Use the sample above to see if it is as per requirement)

mm/dd/yyyy is the default format in MS Excel. You have to create a custom date format for your requirement as it does not exist in excel by default. First select your cells containing dates and right click of mouse and select Format Cells. In Number Tab, select Custom then type 'dd-mmm-yyyy' in Type text box, then click okay. It will format your selected dates.

Imported date-data formatted different from your computer's local setting will be stored as text string. Select the data, one column at at time. Select > Data > Text to Columns, select Delimited > Next, select Tab > Next, select Date and choose from the pull-down menu the format in which the data is present in the text (e.g. DMY or MDY etc.). This will convert the text string into the equivalent Excel date string, after which you can assign it any date format you want.