If your numbers where being entered into Column A,
this formula would *automatically* display them in ascending order in
whichever column you used the formula in:

=SMALL($A$1:$A$100,ROW(A1))

And copy down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"tamato43" wrote in message
...
Is there a way to format cells or columns to automatically re-sort?

I'm importing infomation from another file and I'd like to sort from Hich to
low as the numbers change.