In a certain column I have
1/02/2014 8:43:26 AM
1/02/2014 8:43:29 AM
1/13/14 8:46:38 AM
1/13/14 8:46:40 AM
1/13/14 9:00:00 AM
I want to extract the date, =int(a2) works for the first two items but then returns #VALUE! for the following three.
Also these dates are in mm/dd/yy, is there a way to make them dd/mm/yy?
MQ
Bookmarks