I wonder if you can help me. I have recently purchased MS Office 2003 and I
have a small but annoying problem in Excel.
I am doing a spreadsheet relating to my finances. I have formatted the
figures as currency with 2 decimal places, and the £ symbol as the symbol
before the figures.

In one part of the spreadsheet I have a very simple calculation it is 411.67
* 12
which should equal 4940.04

However, in the spreadsheet it displays the answer as 4940.00

Why is it not adding up the pence correctly? I now it is only a small thing
but in some other spreadsheets if it does that all the time it could make
quite a difference.

I should point out that this is a spreadsheet that was created in Excel from
Office XP.

Whenever I create a blank spreadsheet and try this calculation it works
correctly.

Has anyone else noticed this?

How can I fix it?

I hope you can help me.

I appreciate any help or information given.

Thanks!