How to ensure 2 places to right of decimal

[Shawn]

How can I make certain that decimal values print out 2
places to the right all the time when displaying them on
a website coming from an Access database. Its defined in
the database as a Number, Single, Auto, should I make it
Number, single, 2? I need it to print out like shown
below.


Ex:

1.5 should print out like this 1.50

2.375 should print out like this 2.37

3 should print out like this 3.00

Thanks and Happy Holidays,

Shawn

[Ken Schaefer]

Are you using ASP? If you are using VBScript in your ASP page, then you can
use the FormatNumber() function

FormatNumber(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 control panel. See
Settings section for values.


Cheers
Ken

"Shawn" <programming@jards.com> wrote in message
news:032801c3c9b8$b96ab750$a501280a@phx.gbl...
: How can I make certain that decimal values print out 2
: places to the right all the time when displaying them on
: a website coming from an Access database. Its defined in
: the database as a Number, Single, Auto, should I make it
: Number, single, 2? I need it to print out like shown
: below.
:
:
: Ex:
:
: 1.5 should print out like this 1.50
:
: 2.375 should print out like this 2.37
:
: 3 should print out like this 3.00
:
: Thanks and Happy Holidays,
:
: Shawn

[Bullschmidt]

And just for reference here are some more VBScript (i.e. ASP) functions
too:

VBScript Functions
[url]http://www.w3schools.com/vbscript/vbscript_ref_functions.asp[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!