Strange. Nveer seen it.
So just a few questions.
- You just do ctrl-c on the old cell and ctrl-v on the new cell?
- Does it work correctly in all NEW workbooks and incorrectly in (some) OLD ones? Or isn't it as simple as that?
- If you try Edit>Paste Special and choose 'formulas' or 'all', does it work?