How to change format from mm/dd/year to dd-mmm-yea [Closed]

Report
Posts
1
Registration date
Tuesday August 28, 2018
Status
Member
Last seen
August 28, 2018
-
 Blocked Profile -
hello Seniors,
please solve my query:

I need to change format of data in my excel sheet, for instance data is in the format of mm/dd/year while I want it in dd-mmm-yyyy format.

it changes to my desired vlaue if I change the format first to dd/mm/yyyy and then again change it by formatting the cell.

please provide me with any relevant formula or direct solution to this issue. thankyou.

1 reply

The syntax for changing formatting is as such:
=Text(a1,"dd-mm-yyy")

Where a1 has the date to change! So you may want to hide A column, and make all of these changes in B, then the user will see your format!