Date format

Closed
uru - Apr 1, 2014 at 02:10 AM
iamdinesh Posts 69 Registration date Tuesday December 4, 2012 Status Member Last seen March 9, 2018 - Apr 1, 2014 at 07:07 AM
Hello
when i work in excel format 2007 like dd/mm/yyyy when i import the data some date are convert wrongly like
5/3/2014 (March 5th 2014)

May 3rd 2014 (wrong)

pls help me to keep the data like 5/3/2014 (March 5th 2014)

Thank you
Related:

1 response

iamdinesh Posts 69 Registration date Tuesday December 4, 2012 Status Member Last seen March 9, 2018 22
Apr 1, 2014 at 07:07 AM
it is because your system date is in that format try to change the system date according to your requirment and try
0