Why Don't My Dates Sort Correctly? | Excel Dates Won't Sort - Oldest to Newest or Newest to Oldest
HTML-код
- Опубликовано: 15 окт 2024
- Download the featured file here: www.bluepecant...
In this video I look at why dates won't sort correctly. Dates won't sort correctly when they are stored as text. The first indication that you are in trouble is when Excel offers to sort dates as A to Z or Z to A.
The solution is to convert dates to numeric values and this can be done using Text to Columns.
------------------------
Seems like I forget every time how to do this and I always come back to this video. It helps me a ton at work. Thank you!
Thank you soooooo much!!!! I was already getting crazy for several hours trying to fix it, nothing else helped me until this video!. God bless you!!
tried numerous methods and people trying to explain. this was exactly what I needed literally a life saver! thank you
Thank you the help Chester!! This video was the only one of many that actually helped fix my issue. You're a legend my friend!
Been struggling with this for years! Thank you :)
Thanks heaps, soo easy to follow and straight to the point!!!
Thanks a million! I could not sort the column, even my supervisor! Now I'm on cloud nine:)
Thank you. this very helpful. I keep forgetting that is the text to column option.
Thank you so much for this easy to follow walk-through! Saved me so much time :)
Excellent tip Chester. Thank you for sharing it!!!
THANK YOU!! I've been using excel for eons and never knew this existed. :)
Very Useful, this was the only video I can find with the answer I was looking for!
Fantastic!! This helped me so much with sorting my data!!
Thank you so much for this easy time saving video ! Cheers
THIS SAVED SOME WORK! Thank you!
You explained very well and looks easy.thanks
thank you so much Sir, your video help me solve the problem that i couldn't figure out for a couple of hours, hat off!
Your a dawg Chester, was trying to do this for an hour, your video saved me, cheers!
Really nicely explained, solve my little frustration of the day ;)
Life saver. Thank you so much. Was driving me crazy
Thank you sir, that was really helpful.
Brilliant, This was driving me mad! Much appreciated
Great Help ! Thanks Chester
Made it so easy to understand! Thank you so much 🥲
Thanks Chester. Great tips! Thumbs up!!
Ive done all of the steps but when I select finish not all of my dates shift to the right hand side and I still cannot order them. What can I do then?
Exactly what I needed! Thanks!
So I am having the issue where I wrote a formula to pull a date from a column that has dates in it. If there is no date, my formula does IfError then "" which means it just doesn't display anything. On an old report, where there were many more dates, once I did text to column I could properly sort. On this report, where only about a third of the cells generate a date, it won't let me sort no matter what I do :/. Any ideas? Thanks for the video!
I have struggling with this until this vidoe brilliant!
Thank you, great help!
Great tip! can't thank you enough!
much appreciated! thank you
Thank you Sir.
Thanks for your great help!
How can we turn 19th century dates into date format? I understand all dates are stored in relation to 1/1/1900 but I’m storing older stuff for a history project. Any advice gratefully received
Richard, VBA will recognise those dates.
Thanks so much!
Thanks for sharing! 👍
I literally love you
Thank you.
Would it also work for this
timeline settings
disney animated canon
"Fantasia: Rite of Spring 65,000 BCE
"
"Fantasia 2000: Pomp and Circumstance 1800 BCE
Firebird Suite 1590 BCE
"
Fantasia: The Pastoral Symphony) 1277 BCE
brother bear 10,000 bc
Atlantis The Lost Empire 7000 BC
The Lion King 1178 bce
Hercules 1179 bce
Moana 984 bce
The Sword In The Stone 400s
Mulan 500s
fantasia the sources apprentice 740
fantasia night on bald moutian 1025
The Black Cauldron Dark Ages
Aladdin 800s
Robin Hood 1194
Sleeping Beauty 1300s
The Hunchback Of Notre Dame 1482
The Emperor's New Groove -1500
Snow White And The Seven Dwarfs early 1500s
Pocahontas 1607
Fun and Fancy Free: Mickey and the Beanstal 1734
Beauty & The Beast 1770s
The Adventures of Ichabod 1790
Melody Time: The Legend of Johnny Appleseed 1795
Tangled 1820
Frozen 1820
Frozen 2 1823
Melody Time: Pecos Bill 1858
Alice In Wonderland 1862
Fantasia 2000 the steadfast tin soldier
Cinderella mid 1860s
Tarzan mid 1882
Pinocchio 1883
Make Mine Music: The Martins and The Coys 1885
Make Mine Music: The Whale Who Wanted to Sing at the Met 1886
make mine music casey at the bat 1888
make mine music johny fedora and alice bluebonnet 1889
melody time once upon a wintertime 1890
fantasia nutcraker 1892
Home On The Range mid 1875s
fantasia dance of the hours 1876
The Jungle Book 1893
The Little Mermaid mid 1890s
Basil The Great Mouse Detective 1897
Peter Pan 1900
Mr Toad 1906
Lady & The Tramp 1908
The Aristocats 1910
Atlantis The Lost Empire 1914
The Many Adventures Of Winnie The Pooh 1926
Winnie The Pooh 1926
fantasia 200 RHAPSODY BLUE 1932
make mine music Peter and the wolf 1936
"make mine music blue bayou 1936
"
Dumbo 1941
fun and fancy free bongo 1941
Saludos Amigos 1942
The Three Caballeros 1944
make mine music all the cats join in 1946
melody time little toot 1948
Bambi 1942
fantasia 2000 pines of rome 1924
101 Dalmatians 1961
Rescuers 1-2 1970s
The Fox & The Hound 1981
Oliver & Company 1988
"Fantasia 2000: The Carnival of the Animals 1999
"
Lilo & Stitch 2002
Chicken Little 2002
Meet The Robinsons 2007
Bolt 2008
Super Rhino 2008
Wreck-It Ralph 2012
Big Hero 6 2014
Zootopia 2016
Wreck-It Ralph 2 2018
Meet The Robinsons 2037
Treasure Planet 10000000000000000000...
Thank you for this video.
It didnt work for me, the dates did not rearrange in old to new format
thanks
Thank you very much 👍
It's bonkers that the native data format in Excel does not work and you have to implement a workaround to misleading design. The field of usability and UX began in the 1990s as far as I can tell. What's the logic in shipping updates to essential products without making the basics work?
thank you!!!!
Welcome!
THANK YOU!!
Thanks sir
thank you!
that worked thank you
You legend.
Thanks a bunch, this fixed the issue!
Thank you!!
Thank you!!!