Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field Format
Message
From
13/02/2015 14:12:51
Greg Green
Independent Developer
Lincolnton, Georgia, United States
 
 
To
13/02/2015 11:11:31
Jon Wilshusen
Omaha, Nebraska, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: Field Format
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01615297
Message ID:
01615314
Views:
52
I use the following:

"$ " + ALLTRIM(TRANSFORM(nTotalDistrCost, "999,999,999.99"))

The above will format with commas for the thousands separator and trim to two decimals:

$ 9,999.99
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform