Solved Excel date format solved.

September 27, 2017 at 13:16:49
Specs: Windows 7
Great!! I solve the problem also from DerbyDad03, smart you.
After input date 29-Aug-17, it automatically changed into 0-Jan-00, the formula box shown =8/29/2017, but it won't affect the sort function.
If try to priced with " ' " instead of "=" , it shown 8/29/2017.
Follow your suggestion, "Turning off the Transition option" then, fixed.

See More: Excel date format solved.

Reply ↓  Report •

#1
September 28, 2017 at 00:40:53
Thanks for letting us know, i can not find the previous thread, so i can not mark it as solved.

Simple solutions are often the best


Reply ↓  Report •

#2
September 28, 2017 at 03:41:27
✔ Best Answer
It was already marked as solved back in 2012.

https://www.computing.net/answers/o...

Now the question is: What do we do with this thread? The solution is in the OP, which cannot be set as Best Answer. ;-)

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#3
September 28, 2017 at 03:54:53
Don't know, i did mark like 20 old answers in old threads from 2009 till 2017 as best answered by you.

Was kinda looking for that old thread ^_^.

Will mark #2 as best aswell when i can

Simple solutions are often the best


Reply ↓  Report •

Related Solutions

#4
September 28, 2017 at 06:36:04
To find the original thread I searched for "Transition option". Third thread down on the search results page.

I've set my own answer as "best" in this thread.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

Ask Question