Arrange numbers in a sequence

J

Joe

Hi all,
just wondering if I can arrange numbers in a coloum in a sequence if for
example they are entered as 134526, 146352, 123456 and rearrange them in
order of 123456, 134526, 146352 and so on.

Thanks
Joe
 
P

pdberger

Joe --

Select the range you want to sort, and then click Data>Sort. If you have a
table of multiple columns and you want to keep the rows intact, select the
entire table first, then do Data>Sort. You'll get a window asking which
columns you want to sort by, and whether increasing or decreasing.

HTH
 
J

Joe

Thank You very much pdberger it seems to be working, I hope it will work on
the sheet that I want to sort

Regards

Joe
 
Top