Googles Sheets not sorting in date correctly

Topic

New Reply

Unable to sort in date order using Google Sheets as when l put a date in it is moving to the bottom of the sheet?

Red area below shows correct area it should be in.

Area in yellow shows incorrect area i.e. at bottom of sheet which it now puts date in which is incorrect.

Reply | Quote

Replies

Are you using the same input format, dd/mm vs mm/dd?
Have you pasted the data and carried an extra character across before the date?

cheers, Paul

Reply | Quote

Hi, the dates are set in the correct format ,

 

dd/mm/yyyyy – they are just not sorting correctly

 

 

Reply | Quote

Change the cell format to numbers and compare – dates are just numbers formatted to look like dates.

cheers, Paul

Reply | Quote

Please can you show me a screenshot of what you mean

Reply | Quote

This is a sample I whipped up.

cheers, Paul

Reply | Quote

To which the only thing I would add, if this does not seem obvious, that you need to be clear on which date format you are using.  Paul’s date format is obviously UK, but his sort order would look odd to a reader using US date format.

After a lifetime spent working for American firms, I imposed on myself a rigourous habit of including the month in words, as is 11-Feb-20, Feb-20, etc.  I knew what I meant, and they could see unequivocally what I meant.  I’m not sure that the reverse happened very often.

Dell E5570 Latitude, Intel Core i5 6440@2.60 GHz, 8.00 GB - Win 10 Pro

Reply | Quote

Hi,
It has stopped working since a column has deleted, it is putting dates at the bottom.

In example attached 07/02/2020 needs to be further up the spreadsheet

See attached

Reply | Quote

Hi,

 

I have attached a snipet of the spreadsheet l am using

Reply | Quote

The due date is not sorting correctly when l add a new date

Reply | Quote

I can’t see the issue on my box in LibreOffice.
Maybe you have auto sort on and it’s sorting on something you are not expecting?

cheers, Paul

Reply | Quote

All that was done was that a column was removed, could a setting have been changed?
I dont think autosort was on as all that was done is a column was deleted.

Can you add a date and then try a sort and see if it sorts ok, that would be appreciated.

Reply | Quote

If you deleted the column it was auto-sorting on…

I don’t have Google sheets so I can only speculate.

cheers, Paul

Reply | Quote

Does anyone have google sheets?? who can assist?

Reply | Quote

[access-mdb]

When I tried with Google Sheets, it said it couldn’t sort because of a vertical merge at A1 to A3. Whether this is anything to do with your program I don’t know as I’m unfamiliar with this program.

 

p.s. you can use Google Sheets if you have a Google Account

Eliminate spare time: start programming PowerShell

• This reply was modified 5 years, 2 months ago by access-mdb.

Reply | Quote

Can you send me screenshot when you try and sort on date and the error message

Reply | Quote

As requested. I have a similar error when using Excel (but doesn’t mention which). Is it supposed to autosort?

Eliminate spare time: start programming PowerShell

Reply | Quote

[jabeattyauditor]

The first few rows of columns A – E are merged together for some reason. Undo that bit of nastiness (or exclude that merged row) and the sort will probably work.

• This reply was modified 5 years, 2 months ago by jabeattyauditor.

1 user thanked author for this post.

access-mdb

Reply | Quote