Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 another quick question
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 02 May 2001 :  00:05:24  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
maybe i should goto bed so i can think but ill ask anyway....

i have a number that is different sizes that i would like to format with ,'s in the correct spot. whats the best way to do this? the numbers are basically money figures without the $ so it always ends in with the last three characters being a ".??" where the ?? would be the cents. I hope this makes since. It would need to loop thru incase there is a million dollar order ( i hope ) :O)

Brad

RaiderUK
Average Member

United Kingdom
577 Posts

Posted - 02 May 2001 :  05:14:28  Show Profile  Send RaiderUK a Yahoo! Message
so you would like to turn:

100000 to 100,000
100000000 to 100,000,000

ect.

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 02 May 2001 :  06:35:26  Show Profile  Visit HuwR's Homepage
use the formatcurrency function.

FormatCurrency Function
Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

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

Arguments
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.



Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.49 seconds. Powered By: Snitz Forums 2000 Version 3.4.07