#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Converting

I have a document I put into Excel from MYOB, but I need it to be in a
worksheet format ( with columns and what not) Then, I also need too ssort it
be zip code from smallest to largest, starting with 1. How do I do those two
things? The address list I want to sort also has names, so when I go to sort
it, it does it be name. I need to sort it be zip code. PLEASE HELP ASAP.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Converting

Hi,

What program is the file in? If your data is in a Word table, just select
the entire table and copy it, move to Excel and paste it.

put your cursor in the Zip code column and click the Sort Ascending toolbar
button on the Standard Toolbar.

If this helps, please click the Yes button

"Excel Help Needed!" wrote:

I have a document I put into Excel from MYOB, but I need it to be in a
worksheet format ( with columns and what not) Then, I also need too ssort it
be zip code from smallest to largest, starting with 1. How do I do those two
things? The address list I want to sort also has names, so when I go to sort
it, it does it be name. I need to sort it be zip code. PLEASE HELP ASAP.

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting ASC to csv [email protected] Excel Discussion (Misc queries) 2 April 3rd 23 07:34 PM
Converting xls to ofx Vance Excel Discussion (Misc queries) 8 June 6th 10 01:25 PM
Converting a date to a text field w/o converting it to a julian da LynnMinn Excel Worksheet Functions 2 March 6th 08 03:43 PM
converting [email protected] Excel Discussion (Misc queries) 2 August 4th 06 11:44 PM
converting assi New Users to Excel 1 June 15th 05 04:39 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"