• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

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

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
soppel022200
Asked:
soppel022200
  • 3
1 Solution
 
Nathan Stanford SrSenior ProgrammerCommented:
     #NumberFormat("",'_$____.__')#

   
0
 
Nathan Stanford SrSenior ProgrammerCommented:
#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
 
Nathan Stanford SrSenior ProgrammerCommented:
#NumberFormat("#myvar#",'$____.__')#
0
 
soppel022200Author Commented:
I am impressed! your answer worked. I tried this earlier and it didnt work. I think I left the quotes out.  Thanks!! SteveO
0
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

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now