slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Format Currency

Rafael S.
Posts: 66

Format Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Sep 10 10:41 AM

Hello everyone... How can i format a string variable to currency?

thanks!

Rafael

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Format Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Sep 10 3:08 AM

Under FormatType = ftCurrency & FormatString use %.2m

[Reply][Quote]

Rafael S.
Posts: 66

Re: Format Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Sep 10 5:57 AM

But in code..You know how to do this in the code? Not in the object? Because im trying to do this in a variable.. thanks!

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Format Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Sep 10 6:07 AM

Ah, sorry:

myVal = FormatCurrency (myCurrency,options)

FormatCurrency(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits

Expression
Required. Expression to be formatted.
NumDigitsAfterDecimal
Optional. Numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.
IncludeLeadingDigit
Optional. Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.
UseParensForNegativeNumbers
Optional. Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.
GroupDigits
Optional. Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the computer's regional settings. See Settings section for values.

[Reply][Quote]

Rafael S.
Posts: 66

Re: Format Currency Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Sep 10 10:19 AM

Thank you Mike!!!!!!

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/6/2025 6:57:23 AM