?
Solved

How to keep commas in a NumberFormat Function

Posted on 2010-09-12
3
Medium Priority
?
371 Views
Last Modified: 2013-12-24
I previously asked a question regarding Number Formating with Coldfusion. How would you maintain commas in coldfusions NumberFormat function. Example $200,000.23 NumberFormat("200000.23","$")
0
Comment
Question by:jasch2244
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
cconstable_work earned 2000 total points
ID: 33659446
Set the mask to "$___,___.__" instead of just $?
0
 
LVL 3

Expert Comment

by:cconstable_work
ID: 33659456
Just to add to that basically you want to use the "," character in the mask. you could also use "$," as the mask for any length number and it will just add a "," character every 3 digits.
0
 
LVL 1

Author Closing Comment

by:jasch2244
ID: 33659488
That's a beautiful thing! Thank you :)
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
What You Need to Know when Searching for a Webhost Provider
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

770 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