If your formulas appear as text, then you need to first clear the cells
before entering formulas. Select the cells, hit Edit-->Clear-->All. Save the
file, format the column as General, and try again.
*******************
~Anne Troy
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.
