Previous Topic Next Topic

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
Related:

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.
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel format
D -
sheryljohnson -

1 response
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response