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!

Register Log in
  • 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

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?
 
Sort by date Sort by votes
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
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
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
567
TPG_IT
T
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
856
dgillz
dgillz
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
304
socalvelo
socalvelo
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
400
john432
john432
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
422
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top