manesh,

You could use a formula like:

=IF(A2="Test",TEXT(A1,"%0.00"),TEXT(A1,"$0,000.00" ))

With a similar test for you further formulas.

HTH,
Bernie
MS Excel MVP


"manesh" wrote in message
...

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