OOOH.. I have a DUH!!! here. I didn't recalculate after making the
change in the currency cell. The =CELL() function will not change
until the cell is recalculated! In my system $ returns "C2", all
others return ",2".
Live and learn!!
Good luck.
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=477639