Solved

Formatcurrency Function  is rounding up numbers

Posted on 2001-09-16
1
291 Views
Last Modified: 2008-02-26
<%=Formatcurrency (rs("The_Value"))%>

I use format currency function to write out my dollar amount. This function is rounding up numbers
E.G
$234.49 =$234.5
How do I prevent this from happening?
Thanks

0
Comment
Question by:iyiola
1 Comment
 
LVL 11

Accepted Solution

by:
thunderchicken earned 20 total points
ID: 6486278
<%=Formatcurrency (rs("The_Value"),2)%>

the 2 are the number of digits after the decimal.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to hide jquery hemiintro in returning user? 1 84
Update field in order 21 148
Connection to multiple databases 13 25
send email part1 9 26
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question