Jul 22, 2005 #1 LindaEPI Technical User Jul 16, 2002 37 US my formula is: IF (PART #)= to 123 then $2.00 how do I convert the $2.00 to be a number not text?
Jul 22, 2005 1 #2 lbass Technical User Feb 9, 2002 32,818 US if (PART #) = 123 then 2 Then you can format it with a $ sign by clicking on the icon, if you wish. -LB Upvote 0 Downvote
if (PART #) = 123 then 2 Then you can format it with a $ sign by clicking on the icon, if you wish. -LB
Jul 22, 2005 Thread starter #3 LindaEPI Technical User Jul 16, 2002 37 US DUH! thanks, such a simple thing. I was putting the $$ within the formula. I did as you suggested and it worked. thanks, my friday is looking better Upvote 0 Downvote
DUH! thanks, such a simple thing. I was putting the $$ within the formula. I did as you suggested and it worked. thanks, my friday is looking better