Hi,

I am tearing my hair out trying to make a currency sum appear to two
decimal places without the cell being rounded up as, by doing so, it
gives the 'wrong' amount!!!

For info, the figure in the cell £59.3074. I want it to display £50.30
not £50.31.

Can anyone tell me how to stop it doing this?


--
Bigjohn
------------------------------------------------------------------------
Bigjohn's Profile: http://www.excelforum.com/member.php...o&userid=34784
View this thread: http://www.excelforum.com/showthread...hreadid=545412

you need to include your formula in another function

eg if your original formula was sum(a1:a2)

eg rounddown(sum(a1:a2),2)
or floor(sum(a1:a2),0.01)

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545412

Hi

I'm afraid OP used a simple cell formatting :-))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Dav" wrote in message
...

you need to include your formula in another function

eg if your original formula was sum(a1:a2)

eg rounddown(sum(a1:a2),2)
or floor(sum(a1:a2),0.01)

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545412