Forum Discussion

Kamil Khatib's avatar
Kamil Khatib
Copper Contributor
Nov 25, 2017

Incorrect date sorting. Excel 2013

Hi,

I have a problem sorting by date, i tried the Cell Format thing and also the Text to Columns to identify cells as Date cells , but nothing worked still cells are sorted incorrectly.

 

Anyone can help and tell me how it gonna work?

 

FYI, 

excel

2 Replies

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Jun 27, 2018

    Mr. Kamil

    I observed in your worksheet that there are 'merged rows', could this be the source of your problem?

    HTH

Resources