NumberFormat Assistance 2

[rojas1mg]

I'm having a heck of a time with the NumberFormat. I'm trying to format a dynamic number to show commas in the proper place (i.e. 3000 should be 3,000, or 3000000 should be 3,000,000). This is what I have tried and it's not displaying properly:

NumberFormat(#annual#,mask,)

rojas1mg - - - I love Tek-Tips and all members who reply.

 

[ecobb]

You mean:

NumberFormat(#annual#,'9,999,999.99',)

Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[rojas1mg]

This is what is displaying on my page:

NumberFormat(62500, 9,999,999.99,)

What am I doing wrong? Here's my line of code:

<TD class="total">NumberFormat(#annual#, 9,999,999.99,)</TD>

rojas1mg - - - I love Tek-Tips and all members who reply.

 

[TruthInSatire]

you need to put your mask in quotes. either single or double.

'9,999,999.99' or "9,999,999.99"

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)

 

[rojas1mg]

This is what I ended up having to put:

<cfoutput>#NumberFormat(annual, '99,999,999.99')#</cfoutput>

And now it works. Thanks. I needed the <cfoutput> before and after although I thought one at the top & bottom of my CFM page would suffice....NOPE! Also had to take the #'s from the "annual" off and wrap the whole NumberFormat with it. Thanks

rojas1mg - - - I love Tek-Tips and all members who reply.

 

[TruthInSatire]

If you don't have a book that you can use to look up the syntax for functions and tags you can use the MM live docs website. here is the index.

http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/contents.htm

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
-Douglas Adams (1952-2001)