Hi

Have a look he
http://www.mcgimpsey.com/excel/pennyoff.html

It may help - but then again it may not!! If you post some of your
numbers/formulae it would help us!

Cheers.
Andy.

"Tania" wrote in message
...
im am trying to add cells that are formatted to currency but cant
understand
why it is 1p out?

the cells i am adding have a minus formula in them!

the first five cells add up correctly but if i go over that the sum is 1p
out?

can anyone help?