I have a sheet with many numbers generally in range 1.5-0.5 with lots of decimal places, however google sheets isn't doing sum on them correctly it returns 0.
I need all the decimal places so I can't round or anything.
1
-
3Most likely it's the number format on that cell. – ale Nov 3 '15 at 13:16
4
I believe the data in columns B:E are formatted as text rather than numbers.
In Google Sheets you'd select those cells and choose Format>Number>Number.
See the example here.
-
Yes, try making the columns wider. If the contents align to the left of the cell, it is probably text. – Vidar S. Ramdal Nov 4 '15 at 20:03
