Part 1 of your question cannot be done that I know. I export to Excel, & then delete the last (total) column. You can also "hide" the last column's data by using the format white on white, but the numbers will actually still be there.
Part 2 of your question is easy, just make sure you are using Monarch 7 or better and Excel 97 or better, and then under options, export & Clipboard that the "export & Files types" is set to the Excel 97+ button. Also make sure the "Apply formatting to xls..." box is checked.
Hope this helps
[size="1"][ August 18, 2005, 02:54 PM: Message edited by: Bruce Reed ][/size]