Sounds like you have worksheet set to display formulas not values.
Try CTRL+` ( that on the same key as ~ next to the 1 on top row of
keyboard).
Let us know if this works
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"AOA" wrote in message
...
I have just moved to Excel 2007, and upon opening a frequently used .xls
file, find that no formulas work in it, and all dates have been converted
to
integer values which do not convert to dates using the DATEVALUE function.
Any ideas?