Cannot get a column of numbers to SUM...why?

I have a very large column of numbers I need to sum together using the sum
function, which I use all the time - I down loaded the information from my
bank. The problem I am having, is that no matter what I have tried
(reformating, copying and pasting...) nothing will work, all I get is a 0!
No error, no clue as to what the problem is...just 0. If I type the numbers
in the next column and sum them, it works...but I do NOT want to type in over
3000 numbers! Any ideas as to what the problem could be. I sure would
appreciate any suggestions on resolving this mystery! Thanks! HHG

Think you're received, at last count, 5 responses to your multi-post here and
in .misc (General Questions). Please do not multi-post.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

"HHG" wrote:

> I have a very large column of numbers I need to sum together using the sum
> function, which I use all the time - I down loaded the information from my
> bank. The problem I am having, is that no matter what I have tried
> (reformating, copying and pasting...) nothing will work, all I get is a 0!
> No error, no clue as to what the problem is...just 0. If I type the numbers
> in the next column and sum them, it works...but I do NOT want to type in over
> 3000 numbers! Any ideas as to what the problem could be. I sure would
> appreciate any suggestions on resolving this mystery! Thanks! HHG

I'm sorry! I'm new at this and didn't quite know what I was doing. Thanks
for you previous post, however it did not work...and I am still pulling my
hair out...any other ideas? Thanks - HHG

"Max" wrote:

> Think you're received, at last count, 5 responses to your multi-post here and
> in .misc (General Questions). Please do not multi-post.
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
> "HHG" wrote:
>
> > I have a very large column of numbers I need to sum together using the sum
> > function, which I use all the time - I down loaded the information from my
> > bank. The problem I am having, is that no matter what I have tried
> > (reformating, copying and pasting...) nothing will work, all I get is a 0!
> > No error, no clue as to what the problem is...just 0. If I type the numbers
> > in the next column and sum them, it works...but I do NOT want to type in over
> > 3000 numbers! Any ideas as to what the problem could be. I sure would
> > appreciate any suggestions on resolving this mystery! Thanks! HHG

How about the several other responses ?
Give a go at each response, and feedback to the responders in the threads.
It's always useful to post (in plain text) some samples of your actual data
& set-up. The more the specifics you provide, the less the guessing required
by responders ..

Good luck !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

"HHG" wrote:

> I'm sorry! I'm new at this and didn't quite know what I was doing. Thanks
> for you previous post, however it did not work...and I am still pulling my
> hair out...any other ideas? Thanks - HHG
>
> "Max" wrote:
>
> > Think you're received, at last count, 5 responses to your multi-post here and
> > in .misc (General Questions). Please do not multi-post.
> >
> > --
> > Rgds
> > Max
> > xl 97
> > ---
> > GMT+8, 1° 22' N 103° 45' E
> > xdemechanik <at>yahoo<dot>com
> > ----
> >
> > "HHG" wrote:
> >
> > > I have a very large column of numbers I need to sum together using the sum
> > > function, which I use all the time - I down loaded the information from my
> > > bank. The problem I am having, is that no matter what I have tried
> > > (reformating, copying and pasting...) nothing will work, all I get is a 0!
> > > No error, no clue as to what the problem is...just 0. If I type the numbers
> > > in the next column and sum them, it works...but I do NOT want to type in over
> > > 3000 numbers! Any ideas as to what the problem could be. I sure would
> > > appreciate any suggestions on resolving this mystery! Thanks! HHG