DavidA wrote:
It is difficult to describe!


...and difficult to understand exactly what you mean.
Please could you give the detail.

What cell contains the incorrect data?
What appears in the formula bar when you select that cell?
What are the contents of the cells to which that formula refers?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup