Solved

Getting currency (i.e. $12.57) to display correctly

Posted on 2000-02-22
4
161 Views
Last Modified: 2013-12-24
I really, really need your help.  I have been using cold fusion (learning it).  I am a web page developer and have an account that CF would work with.  I have tried and tried to get it to report my data in currency format and it just won't show up properly.  I'm really frustrated.  My manual is "Cold Fusion 4.0" by Ben Forta.
 
here is an example:
 
Toy Banks
Stock Number Description In Stock Retail Category
16022.0  660 Int. 1999 TF 1st 1/64  5.0  $15.0000  T1  

 
 
As you can see there are decimals that aren't wanted and 4 zeros after dollar amount. If you can tell me what I am doing wrong, please do so. I should also say that MS Access is my database and the cells are formatted as currency and it looks fine there.
0
Comment
Question by:soppel022200
  • 3
4 Comments
 
LVL 5

Expert Comment

by:nathans
ID: 2549034
     #NumberFormat("",'_$____.__')#

   
0
 
LVL 5

Accepted Solution

by:
nathans earned 100 total points
ID: 2549039
#NumberFormat("",'_$____.__')#

$15.00

#NumberFormat("",'$____.__')#

$   15.00

Here are two types.

If you were getting my new ColdFusion Tips Plus e-ZINE you would not have had to ask the question.

Check it out at
http://www.nsnd.com/cftips

or subscribe to the weekly e-ZINE by
emailing a blank email to
subscribe-cftips@nsnd.com



0
 
LVL 5

Expert Comment

by:nathans
ID: 2549045
#NumberFormat("#myvar#",'$____.__')#
0
 

Author Comment

by:soppel022200
ID: 2550417
I am impressed! your answer worked. I tried this earlier and it didnt work. I think I left the quotes out.  Thanks!! SteveO
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 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