Alphabetic vs numeric sort order
Posted: Tue Oct 06, 2009 8:14 am
MINE IS NOT SOLVED. I have a huge problem sorting my OpenOffice Calc data. Seems like an incomplete sort. Both in Excel and odf format with 2,000 rows. Nothing but some phone number formatting with a format code of [<=9999999]#"-"####;(#") "###"-"#### and cell data. I select my full range with the mouse including column header cells. Then use the "data, sort" for my attempt. I sort on three levels but this problem occurs with only one sort level.
The problem is an ascending sort 1100, 11001,... until about row 1,200 then it starts again with 0001 which should sort at the top. This is not the expected behavior of a data sort. How might I fix this?
Any suggestions are appreciated.
The problem is an ascending sort 1100, 11001,... until about row 1,200 then it starts again with 0001 which should sort at the top. This is not the expected behavior of a data sort. How might I fix this?
Any suggestions are appreciated.