Dave Donut
New Member
- Joined
- Dec 19, 2012
- Messages
- 27
- Office Version
- 365
- Platform
- MacOS
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!
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!