Cheryl,

One possibility is that Tools - Options - View - Formulas has been set.
This causes columns to widen, and all formulas to appear as formulas, not
the results in the usual way. Pressing Ctrl ` (the ` character is one key
left of the 1 key) toggles this setting on and off, and could have been
pressed by accident.
--
Earl Kiosterud
www.smokeylake.com

"cheryl" wrote in message
...
Formulas continue to appear as text and will not calculate. how to get
formulas to always calculate.