Hi there all,
first question on here from me,
I am trying to get this spreadsheet to work out loss/gain for weight. All is fine apart from the F column which for some reason keeps producing numbers like the one shown. As can be seen, unless the reference cell is blank, then it is simply initial weight - new weight and then add “kgs” to the end. But as shown in the example, 101.6 - 97=4.5999etc instead of simply 4.6.
I have highlighted the cell and even the column and gone to format and tried to change it so that it shows to 1 or 2 dp but this just does not seem to want to change. Am I missing something obvious here folks?
Thanks in advance