ExcelBanter - Sort problem (Excel 2007)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sort problem (Excel 2007) (https://www.excelbanter.com/excel-programming/437103-sort-problem-excel-2007-a.html)

gcotterl[_2_]

Sort problem (Excel 2007)

Why don't these values sort in ascending order:

035128
035301
035301
035301
031601
035128
035301
031601
033201
035128
035301
033201
035301

joel[_301_]

Sort problem (Excel 2007)

the number do sort properly in 2003. try taking the data you posted and
put it back into the worksheet. You may have some invisible characters
in the data the is causing a problem.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160184

Microsoft Office Help

All times are GMT +1. The time now is 09:00 AM.