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?