software

i can get certain columns to sum, but not others, why???

quot;julie c.quot; wrote:
gt; i can get certain columns to sum, but not others, why???

One guess is that the numbers in the col are quot;text numbersquot;
Try this to convert to real numbers:
Input in an empty cell the number 1, then copy it
Then right-click on the col gt; paste special gt; multiply gt; ok

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Can you post your worksheet here?

Is there anything different about the column that won't sum? Perhaps its
formatting, the way the data was entered, or the layout?

--
-David Dquot;julie c.quot; wrote:

gt; i can get certain columns to sum, but not others, why???

Just started using excel yesterday. This program is great. I realized my
formula resulted in text. Recalculated formula to give a numerical result.
Thanks for your time! I bet I have alot to learn. Thanks again, Julie C.quot;Maxquot; wrote:

gt; quot;julie c.quot; wrote:
gt; gt; i can get certain columns to sum, but not others, why???
gt;
gt; One guess is that the numbers in the col are quot;text numbersquot;
gt; Try this to convert to real numbers:
gt; Input in an empty cell the number 1, then copy it
gt; Then right-click on the col gt; paste special gt; multiply gt; ok
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---

Glad to hear you got it going !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;julie c.quot; wrote:
gt; Just started using excel yesterday. This program is great. I realized my
gt; formula resulted in text. Recalculated formula to give a numerical result.
gt; Thanks for your time! I bet I have alot to learn. Thanks again, Julie C.