Problem with cell category

I choose custom category with


to the cell. And the cell is showing


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
HuaMinChenBusiness 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.
Martin LissOlder than dirtCommented:
Visual Basic Classic topic removed.
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.
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.