?
Solved

Problem with cell category

Posted on 2016-08-04
3
Medium Priority
?
46 Views
Last Modified: 2016-08-04
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?
0
Comment
Question by:HuaMinChen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41743581
Visual Basic Classic topic removed.
0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 1500 total points
ID: 41743590
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
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41743619
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question