help on sorting

[Ray]

Hello, I will need to enter numbers 100 to 5000 + into columns in random
order, is there a way to sort them into correct numerical order at any time
.. I have been told by several Excel " experts " that it cannot be done, I
don't believe this to be true.If this is not enough info, please ask .

Thanks, Ray

 

[Jay]

Hello, I will need to enter numbers 100 to 5000 + into columns in

random order, is there a way to sort them into correct numerical
order at any time . I have been told by several Excel " experts " that
it cannot be done, I don't believe this to be true. If this is not
enough info, please ask .

When you say "into columns" (plural) what do you mean? One number per
column all in the same row? In a rectangular array? Some other arrangement?

What other things are in the cells around the numbers, and on which sides?