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 response

Answer 1 / 1

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.