LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rozzamareea
 
Posts: n/a
Default How do I convert .txt files into .xls in order to be able to sum.

I receive via e-mail a statement that I need to resort by date , purchase
order and total by department, etc. The process I have been using is to copy
and paste into Excel. However, when I try to sum the $ is will not sum.

Is there some other way of converting this statement that I receive via
e-mail into Excel, so that I can resort and sum?

I am using Excel 2002 and my e-mail browser is Mozilla.
 
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
Convert xls files Allen Excel Discussion (Misc queries) 1 June 28th 05 04:49 PM
Convert multiple XLS files to TXT finao Excel Discussion (Misc queries) 2 June 8th 05 03:14 PM
Excel 2003 .XLS files El Maestro Excel Discussion (Misc queries) 0 May 3rd 05 10:53 PM
Importing .txt data files increases .xls file size BrianJ Excel Discussion (Misc queries) 1 January 29th 05 02:02 PM
Must convert 500+ xls files to txt (tsv) KKramsch Excel Discussion (Misc queries) 1 January 5th 05 05:53 PM


All times are GMT +1. The time now is 04:16 PM.

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"