Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal numeric order
I am trying to arrange zip codes in horizontal numeric order so I can read
them like reading a paragraph in a book. How to do this please? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal numeric order
Do you just wish to sort horizontally?
Don't forget, except for XL07, you only have 256 columns! OR Do you want to go out a certain number of columns, and then drop down to the next row, and continue in that fashion? If so, how many columns do you wish to use? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Catana" wrote in message ... I am trying to arrange zip codes in horizontal numeric order so I can read them like reading a paragraph in a book. How to do this please? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal numeric order
"Catana" wrote:
I am trying to arrange zip codes in horizontal numeric order so I can read them like reading a paragraph in a book. How to do this please? One thought. Assume data in A2:A10. Copy the range, then right-click on say, B1 Paste special Check "Transpose" OK. This will paste it horizontally into B1:J1. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal numeric order
Why not just sort them? Just tell Excel you are storing left to right, not
top to bottom. If you need more help, let us know which version of Excel you are using. Regards, Fred. "Catana" wrote in message ... I am trying to arrange zip codes in horizontal numeric order so I can read them like reading a paragraph in a book. How to do this please? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal numeric order
I am using Excel 2003. 11 rows and 8 columns. I have tried selecting all
cells and sorting horizontally but it does not work. Needs to read like a paragraph. 90740 92602 92612 92614 92620 92626 92627 92646 92604 90742 92603 92618 92630 92663 92706 92709 90743 92701 92782 92660 92657 92648 92617 92625 92647 92683 92655 92843 90670 90638 90639 92835 92649 92653 92637 92662 92661 92651 92656 90720 92703 90705 92780 92707 92710 92606 92804 90620 92704 90630 90680 92841 92683 82845 92844 92802 92708 92840 92805 92806 92868 92867 92866 92861 92821 92823 92887 90621 90620 92804 92801 92833 92832 92831 92870 92807 92865 92886 92808 90703 92869 90623 90630 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal numeric order
I tried that first suggestion to copy paste and transpose and I think it will
work. Thanks to all of you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to place a row in numeric/alpheberical order? | New Users to Excel | |||
Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Sort text Values in Numeric Order | Excel Discussion (Misc queries) |