Quite a mystery then <g, given that the usual checks didn't resolve it ..

Perhaps you could use either of the 2 free filehosts listed below to upload
your sample book and then post the link to it in response here (the link is
generated when you upload, just copy and paste it here)

http://www.flypicture.com/
http://cjoint.com/index.php

For cjoint.com (it's in French), just click the "Browse" button, navigate to
folder select the file Open, then click the button centred in the page
below (labelled "Creer le lien Cjoint") and it'll generate the link. Then
copy & paste the generated link as part and parcel of your response here.

Kindly note that no attachments should be posted *directly* to the newsgroup.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kai" wrote:
Hi Max & John,

I'd done all you suggested and checked again. Still, I get $0.00 in the
cell and the formula result remains in the formula box. :(

I have the cell formatted to 'currency.' All my other cells and calcs work
fine.

Kai
San Diego