Need help in date conversion

Closed
MDeepala Posts 1 Registration date Wednesday March 12, 2014 Status Member Last seen March 12, 2014 - Mar 12, 2014 at 01:00 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 12, 2014 at 01:37 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Mar 12, 2014 at 01:37 AM
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
0