Date formatting

Closed

Nigel - 17 Jul 2009 à 02:07
Blocked Profile - 17 Jul 2009 à 06:58

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

Réponse 1 / 1

Blocked Profile
17 Jul 2009 à 06:58

hi,

try this:

click format > format cell > Date

then you may select the date format you want.

this should fix the problem.