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

Closed
laibamahsud1 Posts 1 Registration date Tuesday August 28, 2018 Status Member Last seen August 28, 2018 - Updated on Aug 28, 2018 at 04:58 PM
 Blocked Profile - Aug 28, 2018 at 04:54 PM
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

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!

0