Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Format (99,9999.99) by using STR()
Message
From
14/06/2003 11:10:49
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00800116
Message ID:
00800120
Views:
26
>Hi Everybody
>Numeric field with format 99,9999.99 is working ok. But i have to use the STR() for printout because only STR() is printing local language numeral ok. When I use ALLTRIM(STR(Numeric field,8,2)) with the format 99,9999.99 it does not put the "," on exact position.
>Anyone knows how to do this job.
>Zaheer

Use transform() instead, with the appropriate numeric picture. For instance:
x = 123456789.11
? transform(x, "####,####,####.##")
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform