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!

help with Number conversion

Status
Not open for further replies.
wysiwygger

wysiwygger

Programmer
Jun 20, 2006
78
AU
Hi,

I'm trying to get a number formated like xxx.xx with only 2 digits as cents.

I tried ToNumber but still got the same result: xxx.xxxxx

if {OEORDD.LINETYPE}=1 THEN
ToText({OEORDD.UNITPRICE},{OEORDD.UNITPRCDEC})
else ""

Any help appreciated.
 
Sort by date Sort by votes
sorted:
{OEORDD.UNITPRCDEC} was the field in the database containing the number of decimals.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
464
john432
john432
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
921
dgillz
dgillz
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
220
BradCustom
BradCustom
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
462
john432
john432
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
373
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top