Ask Your Question

Problem with sorting dates [closed]

asked 2013-01-04 01:51:57 +0200

Nerves gravatar image

updated 2013-01-04 08:19:02 +0200

In spreadsheet I have a column of dates near the end of rows of other data. I have formatted them all the same but when I try to sort all data by the dates in that column there's a group of dates that are not integrated properly in the results. Any suggestions?

Update: I've discovered that when I click on a cell that is properly sorted I see "Sum = 12/25/2012" at the bottom of the spreadsheet. When I click on a cell that hasn't been sorted properly I see "Sum =0".

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 19:49:31.653805

1 Answer

Sort by » oldest newest most voted

answered 2013-01-04 09:12:40 +0200

Nerves gravatar image

I discovered the dates that weren't sorting properly had an apostrophe before them that was only visible in the input line. Once I removed that from the cells they sorted properly.

edit flag offensive delete link more

Question Tools


Asked: 2013-01-04 01:51:57 +0200

Seen: 2,449 times

Last updated: Jan 04 '13