How to force all cell contents in a column to be a number?

[Guest]

Changing the cell format from Text to Number, does not change the
contents of the cell to a number as one indeed should expect. How do I
secure that all cells in a column (with some thousand values) are forced to
be added in for example the SUM function? Of course I cannot edit the content
of each cell that continue to be left oriented after formatting the column to
number format.

In short I need a quick way to assure that all thecell values in a column
are regarded as numbers. Otherwise, I simply cannot trust the SUM function
result.

Thanks for any suggestions.

Frank Krogh

 

[Guest]

hi,
this formula worked in xp in a helper column...
=LEFT(A2,LEN(A2)*1)*1
adjust to fit your data. copy down. to convert to hard numbers, copy the
formula colummn(helper column) and paste as values.