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

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

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