Perhaps the calc mode was inadvertently switched to "Manual" instead of
"Automatic"?

Click Tools Options Calculation tab
Ensure that "Automatic" box is checked OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Eddyd" wrote in message
...
I try to copy formulas in adjacent cells. whatever I do the <past special
/
formulas function returns always the value in the original field.