close

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 Datagt;Sort. If you have a
table of multiple columns and you want to keep the rows intact, select the
entire table first, then do Datagt;Sort. You'll get a window asking which
columns you want to sort by, and whether increasing or decreasing.

HTH

quot;Joequot; wrote:

gt; Hi all,
gt; just wondering if I can arrange numbers in a coloum in a sequence if for
gt; example they are entered as 134526, 146352, 123456 and rearrange them in
gt; order of 123456, 134526, 146352 and so on.
gt;
gt; Thanks
gt; 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

Joequot;pdbergerquot; wrote:

gt; Joe --
gt;
gt; Select the range you want to sort, and then click Datagt;Sort. If you have a
gt; table of multiple columns and you want to keep the rows intact, select the
gt; entire table first, then do Datagt;Sort. You'll get a window asking which
gt; columns you want to sort by, and whether increasing or decreasing.
gt;
gt; HTH
gt;
gt; quot;Joequot; wrote:
gt;
gt; gt; Hi all,
gt; gt; just wondering if I can arrange numbers in a coloum in a sequence if for
gt; gt; example they are entered as 134526, 146352, 123456 and rearrange them in
gt; gt; order of 123456, 134526, 146352 and so on.
gt; gt;
gt; gt; Thanks
gt; gt; Joe

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()