Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting text formula to numeric 1

Status
Not open for further replies.

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?
 
if (PART #) = 123 then 2

Then you can format it with a $ sign by clicking on the icon, if you wish.

-LB
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top