Home

column A to be used for date want to enter info out of order and sort do i enter 2 numbers mo,day,

%3CLINGO-SUB%20id%3D%22lingo-sub-896069%22%20slang%3D%22en-US%22%3Ecolumn%20A%20to%20be%20used%20for%20date%20want%20to%20enter%20info%20out%20of%20order%20and%20sort%20do%20i%20enter%202%20numbers%20mo%2Cday%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896069%22%20slang%3D%22en-US%22%3E%3CP%3E01%2F05%2F2019%20will%20thus%20sort%20by%20month%20day%20and%20year%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-896069%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Esorting%20by%20date%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-897218%22%20slang%3D%22en-US%22%3ERe%3A%20column%20A%20to%20be%20used%20for%20date%20want%20to%20enter%20info%20out%20of%20order%20and%20sort%20do%20i%20enter%202%20numbers%20mo%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-897218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421019%22%20target%3D%22_blank%22%3E%40pafuller%3C%2FA%3E%26nbsp%3BI'm%20not%20sure%20what%20the%20question%20is%3F%20What%20happens%20if%20you%20try%20to%20sort%20on%20column%20A%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911162%22%20slang%3D%22en-US%22%3ERe%3A%20column%20A%20to%20be%20used%20for%20date%20want%20to%20enter%20info%20out%20of%20order%20and%20sort%20do%20i%20enter%202%20numbers%20mo%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911162%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20column%20A%26nbsp%3B%20for%20dates%20the%20sort%20does%20not%20give%20me%20a%20chronical%20sort.%26nbsp%3B%20The%20question%3A%20should%20dates%20be%20entered%20as%2001%2F15%2F2019%20giving%20two%20numbers%20for%20month%20and%20day.%20%26nbsp%3B%26nbsp%3B%20I%20do%20not%20have%20all%20of%20the%20information%20to%20build%20the%20spreadsheet%20at%20one%20time%2C%20so%20I%20input%20the%20infor%20as%20I%20get%20it%20and%20want%20the%20end%20result%20to%20be%20based%20on%20date%20entered%20in%20column%20A.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911163%22%20slang%3D%22en-US%22%3ERe%3A%20column%20A%20to%20be%20used%20for%20date%20want%20to%20enter%20info%20out%20of%20order%20and%20sort%20do%20i%20enter%202%20numbers%20mo%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911163%22%20slang%3D%22en-US%22%3EThe%20dates%20do%20not%20sort%20in%20order.%20I%20do%20not%20have%20all%20the%20info%20at%20one%20time%20so%20I%20am%20attempting%20to%20enter%20the%20info%20as%20I%20get%20it%20with%20the%20end%20result%20the%20spreadsheet%20will%20be%20published%20in%20order%20of%20date%3C%2FLINGO-BODY%3E
pafuller
New Contributor

01/05/2019 will thus sort by month day and year

3 Replies

@pafuller I'm not sure what the question is? What happens if you try to sort on column A?

When using column A  for dates the sort does not give me a chronical sort.  The question: should dates be entered as 01/15/2019 giving two numbers for month and day.    I do not have all of the information to build the spreadsheet at one time, so I input the infor as I get it and want the end result to be based on date entered in column A.@Smitty Smith 

Highlighted
The dates do not sort in order. I do not have all the info at one time so I am attempting to enter the info as I get it with the end result the spreadsheet will be published in order of date
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies