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.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI 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.
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.
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...)