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.

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.