Instead of copying the cell itself, select the cell you want to copy, and select and copy the contents of the formula bar.
You can then paste this to a different cell and the contents wont have changes, becasue what you have actually copied is a line of text, not a cell.
The only way I found it was developing a small accounting program, I decided to leave a cell space between the data entered and the calculation to make it clearer,so I cut and pasted the calculations to the right by one cell, and noticed the diference.
I have now sorted the problem by inserting a blank row between the data and the calculation, however it would be very easy to make an error this way without realising what had happened.
This thread is now locked and can not be replied to.