Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing Money Values the way I want to.
Message
From
23/06/1999 12:34:11
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
22/06/1999 20:32:17
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00232788
Message ID:
00233050
Views:
26
>a) Floating '$' directly to the left of the value
>b) Surrounded by parentheses if negative
>c) No space between the '$' and the left parenthesis when number of digits is less than the maximum.
>d) Always a zero to left of point if amount is less than 1 dollar.
>e) Commas at every third digit.
>f) In this case, a maximum of 6 numeral digits to the left of the point.
>
>The following two things yeild the same result and don't work
>
>TRANSFORM(myval,"@($$$$,$$9.99")
>
>TRANSFORM(myval,"@(@T$$$$,$$9.99")
>
>Both of the above put space between the $ and ( and neither prints commas at all??

Try some of these:
?tran(-123.45, "@($ **,**9.99")
?tran(-123.45, "@( **,**9.99")
?tran(-123.45, "@( $**,**9.99")

Note the space between the function and picture clauses. You may want to replace the asterisks with something else or nothing, using CHRT() around this.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform