Currency Format - suppress pence value if pence value is zero

[PaddyDarby]

Hi folks,
hopefully this is an easy one but its got me stumped (doesn't take a lot)

I've a table with currenct values in it ranging from a few pounds and pence to thousands of pounds but no pence. I'd like to set the format so that if the pence value is 0 it displays only the full pounds value (eg. £1024.00 will display as £1024) but any value with a non-zero pence value will display the pence value as well (eg £12.60 will still display as £12.60)...

So if I've a row with the following values...
4.60 10.35 30.00 11564.00 45.50
It'll display as...
£4.60 £10.35 £30 £11654 £45.50

Hope this is clear,
Thanks for any help,
Paddy.

[PaddyDarby]

Got it sorted.... managed to work a round with a condition format...

Paddy