Adding up a column keeps coming up with 'value!'

asked 2018-12-27 13:30:59 +0100

coullclaire gravatar image

updated 2018-12-27 14:15:51 +0100

ebot gravatar image

I've been working with this spreadsheet for months and it now refuses to add up my column of numbers and keeps showing 'value!'. I've tried putting in the formula again, reformatting the column as numbers and a few other ideas found on forums bit to no avail... any ideas?

edit retag flag offensive close merge delete



Do not horizontally align your numeric columns explicitly. Then you will clearly see if there are numbers contained. (Texts left aligned, numbers right aligned.)
Formatting of a column "as numbers" does not convert text to numbers!
We would need to see a piece of your spreadsheet showing the issue.
Please provide access to a respective .ods file.

Lupp gravatar imageLupp ( 2018-12-27 14:44:53 +0100 )edit

For quick test to check if reffered cells contain numbers or text strings, you can use View -> Value Highlighting from menu. Numbers font will become blue, formulas - green, text - black. In any case, as @Lupp mentioned, example file is needed to provide correct suggestions, not guessing.

SM_Riga gravatar imageSM_Riga ( 2018-12-27 18:43:27 +0100 )edit