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

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

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

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

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses