Changing Text to numbers

[amfroehlich]

I exported a file from Crystal reports to excel and the negative numbers are coming out as text and not numbers.

For example (1222.00)

So if i want to sum some of these numbers up i have to delete the brackes. Is their a good way to say these are all numbers...

 

[Oaktree]

Format your cells as numbers, or use =value(a1)

 

[Scott Huish]

To convert it to a number:
=--A1

or you could use something like this:

=SUMPRODUCT(--(A1:A100))

 

[robertkrz]

How to use sum from other workbook ?

Hi
Does anybody know how to use this with references to other workbook?

I mean I suspec to use:

=SUMPRODUCT([db.xls]Sheet1!--($G$8:$G$10000))

but this doe not work !

Any hints are appreciated !

BR,
R.

 

[Oaktree]

Your sheet/file names go with the range.

=SUMPRODUCT(--([db.xls]Sheet1!$G$8:$G$10000))