Cannot use advanced sorting after .cvs import

[strat919]

I have tried over an hour and cannot figure out why it won't sort correctly. I have imported a .cvs file and delimited.

I am trying to sort with 2 levels on 2 columns. It sorts fine when I only sort 1 level. When I sort with 2 levels, the 1st level sorts correctly, but the second level I create does nothing.

I did a test with a fresh spreadsheet just entering random values and the 2 level sorting worked correctly.

It doesn't like my .cvs imports for some reason.

One of the columns I have is numbers and letters, but I tested by changing to all numbers and that didn't make any difference.

Any help would be appreciated

David

 

[mole999]

did you save into native excel format after import

 

[strat919]

Hey.... thanks....it was a formatting issue and that solved it