Are you copying and pasting between workbooks perhaps. If so then check to
see if the workbooks are in seperate instances of XL. That would cause the
behavior you are describing...
--
HTH...

Jim Thomlinson


"Bill B" wrote:

Something happened. Now I can't copy and paste a formula from one cell to
another in my worksheet??? It only want's to paste text.
Even with paste special, I have lost the old dialog box and have a new one
that only allows pasting text.