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

Posted on 2000-02-22
Medium Priority
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.
Question by:soppel022200
  • 3

Expert Comment

ID: 2549034


Accepted Solution

nathans earned 400 total points
ID: 2549039



$   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

or subscribe to the weekly e-ZINE by
emailing a blank email to


Expert Comment

ID: 2549045

Author Comment

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

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
Media Temple is proud to announce our partnership with the Society of Digital Agencies (SoDA) as their exclusive hosting partner.
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

622 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