Display Currency Fields in ASP

Question:
I am querying an Oracle field that comes back in the format of 25.5. Because this is a currency field, I’d like to manipulate it so that it shows $25.50 before I publish it out to the Web. How can I do this?

Answer:

Use the FormatCurrency function in VBScript.

strVar = "25.5"' -- the next line outputs $25.20, the 2 refers to' -- the number of decimal placesresponse.write FormatCurrency(strVar, 2)

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

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: