Why Don't My Dates Sort Correctly? | Excel Dates Won't Sort - Oldest to Newest or Newest to Oldest
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 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!!
Thanks a million! I could not sort the column, even my supervisor! Now I'm on cloud nine:)
Your a dawg Chester, was trying to do this for an hour, your video saved me, cheers!
Thanks heaps, soo easy to follow and straight to the point!!!
tried numerous methods and people trying to explain. this was exactly what I needed literally a life saver! thank you
Thank you. this very helpful. I keep forgetting that is the text to column option.
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!
THIS SAVED SOME WORK! 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 :)
Excellent tip Chester. Thank you for sharing it!!!
Thank you so much for this easy to follow walk-through! Saved me so much time :)
I have struggling with this until this vidoe brilliant!
Great Help ! Thanks Chester
Brilliant, This was driving me mad! Much appreciated
THANK YOU!! I've been using excel for eons and never knew this existed. :)
Thank you so much for this easy time saving video ! Cheers
Fantastic!! This helped me so much with sorting my data!!
Thank you sir, that was really helpful.
Thank you, great help!
Life saver. Thank you so much. Was driving me crazy
You explained very well and looks easy.thanks
much appreciated! thank you
Really nicely explained, solve my little frustration of the day ;)
Exactly what I needed! Thanks!
Made it so easy to understand! Thank you so much 🥲
Thank you Sir.
Great tip! can't thank you enough!
Thanks so much!
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?
Thanks Chester. Great tips! Thumbs up!!
Thank you!!
Thank you for this video.
I literally love you
thanks
Thank you very much 👍
Thanks for your great help!
THANK YOU!!
Thanks for sharing! 👍
thank you!
thank you!!!!
Welcome!
Thank you.
that worked thank you
It didnt work for me, the dates did not rearrange in old to new format
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.
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...
Thanks a bunch, this fixed the issue!