Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Al
As Bill has pointed out, they may be text. Sometimes simply reformatting may not do it. Copy a blank cell and then editpaste special...values+add the 'text' numbers and they should budge to numbers. (Don't do this over formulae or you will kill it/them) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Uncle Al" <Uncle wrote in message ... I am sorting a list of numbers containing 100510 and 10160 and 100510 comes out before 10160 which is out of order. How do I get them to sort properly? |