1

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.

Sum not working properly

  • 3
    Most 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.