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

Closed
laibamahsud1 Posts 1 Registration date Tuesday 28 August 2018 Status Member Last seen 28 August 2018 - 28 Aug 2018 à 14:17
 Blocked Profile - 28 Aug 2018 à 16:54
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 response

Blocked Profile
28 Aug 2018 à 16:54
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!