See

http://www.mcgimpsey.com/excel/pennyoff.html

In article <44b248d5$0$10940$fa0fcedb@news.zen.co.uk>,
"Neil Hindry" <n_nospam_hindry@_nospam_hotmail.com> wrote:

> 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!