software

Please help, I have a very long list of figures for which I need a total.
They have been listed without 'thousand separator'. Now I cannot format the
cells to have the 'thousand separator' and neither Autosum or Formula for
addition will not work.
--
Cheers

It sounds like probably your quot;numbersquot; are actually TEXT formatted. There
are several methods to make the conversion back to numbers, sometimes one
works where the others won't.....dunno why. Try typing a 1 in an unused
cell, then clicking on it and oing COPY, then clicking on your column of data
and doing PasteSpecial gt; Multiply..........

There are other ways if that one don't work.

Vaya con Dios,
Chuck, CABGx3
quot;LSP Margquot; wrote:

gt; Please help, I have a very long list of figures for which I need a total.
gt; They have been listed without 'thousand separator'. Now I cannot format the
gt; cells to have the 'thousand separator' and neither Autosum or Formula for
gt; addition will not work.
gt; --
gt; Cheers