Date formate

[Closed]
Report
-
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
-
Hello,

please help me,

i have software date format {15/03/2016 5:26 PM} and i need convert to this format {Mar/14/2016}




1 reply

Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
Hi Munawwer,

Try:
Right-click > cell properties > Number tab > custom > mm/dd/yyyy.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!