I have a cell that needs to change from a % to a $ depending on a
validation dropdown list. Once it has been set, I need to be able to
tell the difference between the % and the $ in a couple formula's in
the same sheet.

Thanks


--
manesh
------------------------------------------------------------------------
manesh's Profile: http://www.excelforum.com/member.php...o&userid=33268
View this thread: http://www.excelforum.com/showthread...hreadid=530897