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

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

After importing a csv file with a column with different decimal values and applying Tom Woodward solution I got some crazy numbers. What worked for me was to select the columns and click first on Format>Number>Plain Text & second Format>Number>Number . Aparently some of the decimal values where considered dates after importing the csv file..(only when using Spanish as main language for the document...)

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.