did you format it to be currency *with* the ero symbol? if you just set
the cell as currency it will default to $.
--
TheIrishThug
------------------------------------------------------------------------
TheIrishThug's Profile:
http://www.excelforum.com/member.php...o&userid=29682
View this thread:
http://www.excelforum.com/showthread...hreadid=496520