Excel 2003. A schedule template used for years has never had this issue until the new user started and I can't reproduce the error because we never see it happen, only that it HAS.
Cells have content like 'ABC0012' or 'DEF3452' These are entered by typing, pasting, dragging, any number of ways, as they represent scheduled events.
THE PROBLEM: the discovery is made that what used to be 'ABC0012' is now 'ABC+Q14070012' or 'DEF3452' is now 'DEF+L16023452'
It seems to be inserting a cell address in the middle of the cell content. there is no preceding equal sign which might explain address insertion, but it certainly acts like that. AND it is always found later and never noticed when it occurs, so far.
Any key combination that might explain this? Or setting?
I neglected to mention, there are two macros on the sheet.
Worksheet_SelectionChange which checks if the active column is X and if it is, recalculates X2
and
Worksheet_Before_DoubleClick which does a lookup based upon the cell content and displays sales history based on that content in a form. Nothing is written to cells in either macro.
Thanks