format total

Adam H-W · September 27th, 2004, 09:23 AM

Hi there

Simple question - how do you format a number so that it outputs to a correct currency decimal place? i.e from 22.5 to 22.50?

thanks

Adam

ChrisScott · September 27th, 2004, 09:51 AM

Hi Adam,

If you're using VBScript, you can use FormatCurrency or FormatNumber, I tend to steer clear of FormatCurrency as this bangs a currency sign in based on your servers setiings.

Code:

formattedNumber = FormatNumber(yourNumber, decimalPlacesRequired)

If you're using JScript, you can roll your own function to do the same thing

Code:

function FormatNumber(pNum, pDPs){
    return (pNum * Math.pow(10, pDPs)).toString().replace(new RegExp("^(\\d*)(\\d{" + pDPs + "})$"), "$1.$2");
}

HTH,

Chris

Adam H-W · September 27th, 2004, 09:55 AM

great, thanks