Problem with cell category

Hi,
I choose custom category with

d/m/yyyy

to the cell. And the cell is showing

6/1/2016

but if I've double-clicked it, it then becomes 1/6/2016. I think this is a confusion there. How to avoid it?
LVL 11
HuaMin ChenSystem AnalystAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
The U.S. uses a weird "mm-dd-yyyy" date format which makes it confusing to the rest of the world. To counter this, I always use the date format "dd-mmm-yyyy" so today's date will show as 05-Aug-2016 and not 5/8/2016 which could mean 5th of August, or 8th of May depending on your localisation settings.
1
 
Martin LissOlder than dirtCommented:
Visual Basic Classic topic removed.
0
 
Wayne Taylor (webtubbs)Commented:
Thank you for accepting my solution.

However, you have yet again only given my solution a "B" grade. You seriously need to reconsider your grading choices and I recommend you read below article.

http://support.experts-exchange.com/customer/en/portal/articles/481419-what-grade-should-i-award-?b_id=44
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.