Solved

Formatcurrency Function  is rounding up numbers

Posted on 2001-09-16
1
281 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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 …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now