Summing Parts of Cells?

[Dave Donut]

In the D column of a downloaded sheet I have figures e.g. in D1 I have 50.00 (50.00)

I want to total the 50.00 numbers.

In column E I have used =LEFT(D1,4) to extract the 50.00 - which is what I want.

I want to sum column E numbers. If I use =SUM(E1:E100) this returns 0. However, if I use =E1+E2+E3 etc, I get the correct total.

Why would this be? And, is there a way to avoid using all those plus signs.

Thanks!

 

[Fluff]

You can use

=LEFT(D1,4)+0

to convert the text into numbers.

 

[Dave Donut]

Fluff!

You have helped me twice in two days!

Thanks again.

 

[Fluff]

You're welcome & thanks for the feedback.