software

I create files using SAS, outputting to an HTM file, which opens up
easily in Excel. If I drag the cursor over a few cells I do not get
the 'sum=....' note at the bottom, which happens with a regular XLS
sheet.

If I use the sum function, 'sum(b2:b4)', I'll get a result of 0, but if
I enter '=b2 b3 b4' I get the correct number.

Anyone know of what might be causing this and how to correct?

Thanks for any help.The SUM() function ignores non-numeric (text) numbers.
If you check the format of your imported data you'll find that it's probably
'Text'.

To convert those quot;nonquot; (text) numbers to true XL recognizable numbers, right
click in a new, unused cell, and choose quot;Copyquot;.
Select those text numbers and right click in that selection.
Choose quot;PasteSpecialquot;, then click quot;Addquot;, then OK, then lt;Escgt;.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;nrquot; gt; wrote in message ups.com...
gt; I create files using SAS, outputting to an HTM file, which opens up
gt; easily in Excel. If I drag the cursor over a few cells I do not get
gt; the 'sum=....' note at the bottom, which happens with a regular XLS
gt; sheet.
gt;
gt; If I use the sum function, 'sum(b2:b4)', I'll get a result of 0, but if
gt; I enter '=b2 b3 b4' I get the correct number.
gt;
gt; Anyone know of what might be causing this and how to correct?
gt;
gt; Thanks for any help.
gt;