Arrange numbers in a sequence
 

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

Arrange numbers in a sequence
 

Joe --

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

HTH

"Joe" wrote:

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

Arrange numbers in a sequence
 

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


"pdberger" wrote:

Joe --

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

HTH

"Joe" wrote:

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