Cheers for the help guys!

I set it up originally with a column for the amount and a column where
you could select the currency from a list (a message states that an
entry must be made and it provides the two options).

I have then used that as the basis for my IF statement. I was just
hoping that you could avoid the 'Currency Column' and enter the values
in the following format £xx.xx or $xx.xx

It doesn't appear to be possible to simply find the £ or $ sign and run
an IF statement off that though.

Thank you anyway for your suggestions


--
SkyBluesFan
------------------------------------------------------------------------
SkyBluesFan's Profile: http://www.excelforum.com/member.php...o&userid=28215
View this thread: http://www.excelforum.com/showthread...hreadid=477639