Date formatting

Closed
Nigel - Jul 17, 2009 at 02:07 AM
 Blocked Profile - Jul 17, 2009 at 06:58 AM
Hello,
I have a data which has a few dates entered as mm/dd/yy and few dates entered as dd/mm/yy. Can you help to get the in dd/mm/yy format.



Thanks

1 reply

Blocked Profile
Jul 17, 2009 at 06:58 AM
hi,

try this:

click format > format cell > Date

then you may select the date format you want.

this should fix the problem.
0