Thread: +(-)ve values ends in Dr(Cr)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
daddylonglegs[_42_] daddylonglegs[_42_] is offline
external usenet poster
  
Posts: 1
Default +(-)ve values ends in Dr(Cr)

I don't think you can do that will simple formatting but you coul
convert with a formula in another column...

=LEFT(A1,LEN(A1)-2)*IF(LEFT(RIGHT(A1,2))="D",-1,1

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=55535

Reply With QuoteReply With Quote