Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
You might be able to use File--Open, and then let the Text Import Wizard
help. Otherwise, you could use the "data isn't recognized" fix he http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "rozzamareea" wrote in message ... 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. |
#3
|
|||
|
|||
rozzamareea wrote:
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. Just a guess but the field is probably formatted as text even though it shows a $ sign high lite the $col right click and format as currency. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert xls files | Excel Discussion (Misc queries) | |||
Convert multiple XLS files to TXT | Excel Discussion (Misc queries) | |||
Excel 2003 .XLS files | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Must convert 500+ xls files to txt (tsv) | Excel Discussion (Misc queries) |