I cannot get a column of numbers to sum, why?

[HHG]

I have tried everything! I have a column of numbers that I need to add
together, and I cannot get it to work. All I get in a big fat 0! I down
loaded the information from my bank. I have tried reformatting the cells,
but nothing seems to help. If I type in the numbers in the next column, and
use the sum function, it works...but I do not want to type in over 3000
numbers! I have even tried copying and pasting the column to another
column...I am stumped...can anyone help - PLEASE!

[Max]

Try this:

Right-click on an empty cell > Copy

Then select and right-click on the column of numbers
Choose Paste special > Add > OK

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

"HHG" wrote:

> I have tried everything! I have a column of numbers that I need to add
> together, and I cannot get it to work. All I get in a big fat 0! I down
> loaded the information from my bank. I have tried reformatting the cells,
> but nothing seems to help. If I type in the numbers in the next column, and
> use the sum function, it works...but I do not want to type in over 3000
> numbers! I have even tried copying and pasting the column to another
> column...I am stumped...can anyone help - PLEASE!

[CLR]

Backup your data first, then highlight the column and try Data > Text to
columns > Delimited > and un-check all delimiters.....with General
format..............then try re-formatting the column to
general.............

Vaya con Dios,
Chuck, CABGx3


"HHG" <[email protected]> wrote in message
news:[email protected]...
> I have tried everything! I have a column of numbers that I need to add
> together, and I cannot get it to work. All I get in a big fat 0! I down
> loaded the information from my bank. I have tried reformatting the cells,
> but nothing seems to help. If I type in the numbers in the next column,
and
> use the sum function, it works...but I do not want to type in over 3000
> numbers! I have even tried copying and pasting the column to another
> column...I am stumped...can anyone help - PLEASE!

[HHG]

Thanks for your help...however it did not work, I didn't have any delimiters
- but I went ahead and did what you said anyway...but unfortunately it didn't
work. I'm totally confused about this...I have never had this problem
before. Any more ideas? They would be greatly appreciated! Thanks again! -
HHG
"CLR" wrote:

> Backup your data first, then highlight the column and try Data > Text to
> columns > Delimited > and un-check all delimiters.....with General
> format..............then try re-formatting the column to
> general.............
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "HHG" <[email protected]> wrote in message
> news:[email protected]...
> > I have tried everything! I have a column of numbers that I need to add
> > together, and I cannot get it to work. All I get in a big fat 0! I down
> > loaded the information from my bank. I have tried reformatting the cells,
> > but nothing seems to help. If I type in the numbers in the next column,
> and
> > use the sum function, it works...but I do not want to type in over 3000
> > numbers! I have even tried copying and pasting the column to another
> > column...I am stumped...can anyone help - PLEASE!
>
>
>

[Arla M]

This is just a guess... But why not try Copy > Paste Special > Values into a
column. Obviously there is something wrong with the data, so if you copy
only the numeric values then perhaps it will work? Maybe to be on the safe
side, copy onto a blank sheet?

Good luck
Arla

"HHG" wrote:

> I have tried everything! I have a column of numbers that I need to add
> together, and I cannot get it to work. All I get in a big fat 0! I down
> loaded the information from my bank. I have tried reformatting the cells,
> but nothing seems to help. If I type in the numbers in the next column, and
> use the sum function, it works...but I do not want to type in over 3000
> numbers! I have even tried copying and pasting the column to another
> column...I am stumped...can anyone help - PLEASE!