On Tue, 6 May 2008 04:29:01 -0700, Colin G
wrote:


Ron, it is just a number not a formula.

Spiky, the spreadsheet does originate from an earlier version (in fact, I
think it was originally a lotus one!) so I guess that is the answer. Not
really a problem in as much as it is just one extra item to remember to
change but would have been nice to have automated it. Maybe I need to spend a
month or so totally rewriting the whole thing.

Thanks to you all for comments


If the original sheet was from Lotus, that is, indeed, the problem.

Find the Lotus compatibility settings (it's on one of the tabs under
Tools/Options in pre-2007; and under Excel Options/Advanced in 2007) and
DEselect Transition Formula Evaluation (and any other Lotus options you may not
want).
--ron