[SOLVED] How do I convert .txt files into .xls in order to be able to sum.

[rozzamareea]

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.

[Anne Troy]

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 here:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"rozzamareea" <[email protected]> wrote in message
news:[email protected]...
>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.

[gls858]

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