Sounds like you need to force the cells to number type.

Enter 1 in a blank cell and copy the cell.

Highlight your set of numbers, paste special/multiply.

This will force them to number, and should allow a correct sort.

"m" wrote:

I have a list w/ numbers, dates and description; attempting to sort the list
in number order but it is not recognizing the difference between e.g., 1400
and 14000 or 1623 and 16233 so it's sorty them together. Any help would be
appreciated. I've changed the format to number, text but still not correct
results.