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|?
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|?
My Computer
- Computer type
- PC/Desktop
- OS
- Windows 7 Home Premium 64bit.
- CPU
- Intel Core i5-2500k Quad @ 3.3GHz
- Motherboard
- ASUSTeK P8Z68-V LE (LGA1155)
- Memory
- 8.00 GB Dual-Channel DDR3 @ 666.7MHz (5-5-5-15)
- Graphics Card(s)
- PL2773HDs on AMD Radeon HD 6600 Series
- Monitor(s) Displays
- Llyama PL2773HDS
- Screen Resolution
- 1920x1080 pixels
- Hard Drives
- SAMSUNG HD103SJ ATA Device 1TB