I wonder if anyone can advise on the following please?
I have a long standing workbook in which one particular worksheet has suddenly started to operate strangely - when I insert figures into a column which is set up to be auto-summed, as soon as the second number is entered the sum becomes what appears to be a combination of the two numbers overlaid upon each other. Any consequent calculation involving that cell in say the row, also takes on the 'overlay' appearance.
I have tried test auto-sum etc on other worksheets in the same book and it would appear that the problem lies with this one sheet. It is confusing me, does anyone have any ideas please|?