I did try out my cell function and it worked for me.

I.e. "c2" picked up any amount formatted in dollars and ",2" recognised
the pounds.

So there.............( :)

Now, it could well be that the c2 will pick up the default currency
format, and the ,2 picks up a different one.

You may have to check on your system.
Just format some numbers and use the function =CELL("format",A1)
to see what's what.

feed back please
always willing to learn


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=477639