Need help in date conversion

[Closed]
Report
Posts
1
Registration date
Wednesday March 12, 2014
Status
Member
Last seen
March 12, 2014
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Please help me with a formula to convert ' 17/08/2013 02:06:02 PM' to ' 08/17/2013' in XLSX . Thank you.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
you must understand that dates should be entered according to your regional convention of your computer either m/d/yy or d/m/yy
click control panels-region and language and choose format menu at the top

once you enter according to regional convention then you can FORMAT as you lilke

but remember this is only FORMATTING, THAT IS HOW IT LOOKS TO YOU. basic entry will be according to regional convention and the value will be a number