Total of Potentials

Total of Potentials

How can I see the sum total of value of amount or expected revenue for the potentials that I have uploaded?
If I export to excel the amounts are in text and not number format and so I can not Sum there.