This is a strange one. Using Office 07. Create simple formula:
=C23-G23 (Returns 00.0 when itshould be 175.00)

When Formula Options is set to manual, the formula works. When set to
Automatic, it doesn't.

Is there some other setting prohibiting the formula from working properly?

--
rpw