I just today started having the same issue. I would copy a range of
cells with data and formulas to a neighboring range and all the
formulas in the new (copied to range) were gone, being replaced by the
value, but evidently as "Unicode??"

If I select them one cell at a time and copy them and then do a "paste
special" the formulas option shows up, but if I attempt multiple cells
and do "paste special" I get paste as Unicode text or text. What
happened?? Is there an option setting that got altered? I am running
Excel 2000 build (9.0.2812)

any help would be appreciated...


--
pwlyons
------------------------------------------------------------------------
pwlyons's Profile: http://www.excelforum.com/member.php...o&userid=25053
View this thread: http://www.excelforum.com/showthread...hreadid=350441