Double # for each # you want to use...
-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Tuesday, August 09, 2011 2:19 PM
To: cf-talk
Subject: Using excel NumberFormat in coldfusion
Hi All -
As suggested by a couple of coldfusion developers a weeks ago
"##,0" doesn't work?
-Original Message-
From: fun and learning
Sent: Tuesday, August 09, 2011 3:18 PM
To: cf-talk
Subject: Using excel NumberFormat in coldfusion
Hi All -
As suggested by a couple of coldfusion developers a weeks ago, I am using xml
to genera
ss:Color="#00"/>
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
ss:Color="#00"/>
</Borders>
<NumberFormat ss:Format="
> Ray Camden has blogged about column rendring, maybe you check that out.
>
>
>
> On 9/21/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote:
> > I just need to add commas to a grid column that are displaying
> numbers. I think I need to use numberformat but
Hi Steve,
I also have a post about cell renderers you can see it here
http://www.garyrgilbert.com/blog/index.cfm/2007/8/24/CFGRID-Cell-Renderer-Revisited
--
Gary Gilbert
http://www.garyrgilbert.com/blog
~|
ColdFusion 8 - Build
Ray Camden has blogged about column rendring, maybe you check that out.
On 9/21/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote:
> I just need to add commas to a grid column that are displaying numbers. I
> think I need to use numberformat but I am not sure how to use it.
>
>
I just need to add commas to a grid column that are displaying numbers. I think
I need to use numberformat but I am not sure how to use it.
Any help would be great.
~|
ColdFusion is delivering applications solutions at at top
Hi,
Coldfusion5 + cfgrid + numberformat does not work
Normall in a table this works: #LSNumberFormat(SumInv,"_-_,___,___.__")#
it will display as : 4,100.00 which is correct.
but when in a cfgrid
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Arch
That did it. Thanks Peter.
On 3/21/07, Peter Boughton <[EMAIL PROTECTED]> wrote:
>
> Try setting type to currency.
>
>
>
~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://ww
Try setting type to currency.
ie:
>I have this line of code:
>
>numberformat="$__.__">
>
>The problem is that I am not getting the properly formatted number. My
>column just shows someting like 22369.22 rather than @22369.22. In the
>table, the data is ente
I have this line of code:
The problem is that I am not getting the properly formatted number. My
column just shows someting like 22369.22 rather than @22369.22. In the
table, the data is entered as 22369.22 and the field is a type of Money.
Thanks,
--
Bruce Sorge
"I'm a mawg: half man, half
>
> VARIABLES.someVar = "350";
> VARIABLES.digit2 = VARIABLES.someVar / 1024 / 1024;
> VARIABLES.ImageMaxFileSize1 =
> NumberFormat(VARIABLES.digit2, ",._") & "mb";
>
> writeOutput( VARIABLES.ImageMaxFileSize1 );
Wo
That worked. Thanks!
Thanks,
Mark
-Original Message-
From: Mingo Hagen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 11:01 AM
To: CF-Talk
Subject: Re: NumberFormat problem
Hey Mark,
how about this:
VARIABLES.someVar = "350";
VARIABLES.digit2 = VARIABL
Hey Mark,
how about this:
VARIABLES.someVar = "350";
VARIABLES.digit2 = VARIABLES.someVar / 1024 / 1024;
VARIABLES.ImageMaxFileSize1 = NumberFormat(VARIABLES.digit2, ",._") &
"mb";
writeOutput( VARIABLES.ImageMaxFileSize1 );
Mingo.
Mark Led
S.digit2 = Left(VARIABLES.someVar, 2);
VARIABLES.ImageMaxFileSize1 = "#NumberFormat(VARIABLES.digit2, "L.9")#mb";
#VARIABLES.ImageMaxFileSize1#
I want the output to be "3.5mb"
Thanks,
Mark
~|
Message
Thanks Guy's
Al
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 12:09 PM
To: CF-Talk
Subject: RE: NumberFormat , Help
> Isaac,
> Wouldn't this work as well?
> #numberformat(var * 100, "")#
It woul
> Isaac,
> Wouldn't this work as well?
> #numberformat(var * 100, "")#
It would... I used repeatString(0,12) for legibility -- and because if
the length of the string changes, it's easier to change 12 to another
number than to count the number of zer
Isaac,
Wouldn't this work as well?
#numberformat(var * 100, "")#
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 9:40 AM
To: CF-Talk
Subject: Re: NumberFormat , Help
> I have a dollar value of ($73.60)t
> I have a dollar value of ($73.60)thats stored in the
> database as 73.6. I
> would like to format this number and display it as a
> twelve digits
> ("0007360"). Similarly if the value is 12 the format
> shoshould be
> (0001200)
> Any help would be
Cheap and nasty:
right("" & YourValue * 1000, 12)
HTH
Aaron
Aldon Moore wrote:
>I have a dollar value of ($73.60)thats stored in the database as 73.6. I
>would like to format this number and display it as a twelve digits
>("0007360"). Similarly if the value is 12 the format shos
I don't think you can do it in one step. However, this should work:
#replace(numberFormat(myNumber, "000.00"), ".", "")#
cheers,
barneyb
On 7/26/05, Aldon Moore <[EMAIL PROTECTED]> wrote:
> I have a dollar value of ($73.60)thats stored in th
I have a dollar value of ($73.60)thats stored in the database as 73.6. I
would like to format this number and display it as a twelve digits
("0007360"). Similarly if the value is 12 the format shoshould be
(0001200)
Any help would be appreciated.
~
> Thanks guys. I checked cflib but missed this.
> Sincerely,
> Andrew
Welcome. It was something I'd seen in the code recently at my 9-5 job,
otherwise I likely wouldn't have been able to offer the suggestion. :)
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add featur
Thanks guys. I checked cflib but missed this.
Sincerely,
Andrew
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 10:24 AM
To: CF-Talk
Subject: Re: Easy NumberFormat Question
Sierra Bufe submitted this udf to cflib.org:
function
re a number formatting function that will show a
> maximum of two
> decimal places when a remainder exists and no decimal
> places if it
> doesn't exist? Right now I'm using numberformat and it's
> showing two
> decimal places when there is no remainder. I'd jus
You can use...
To get you desired formatting.
--
Jay
> -Original Message-
> From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
> Sent: 24 November 2004 15:20
> To: CF-Talk
> Subject: Easy NumberFormat Question
>
> Hello,
>
> Is there a number formattin
Hello,
Is there a number formatting function that will show a maximum of two
decimal places when a remainder exists and no decimal places if it
doesn't exist? Right now I'm using numberformat and it's showing two
decimal places when there is no remainder. I'd just like for th
[mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:47 PM
To: CF-Talk
Subject: RE: numberformat
0.07
is what that code shows
sorry. i thought so too!!
tony
-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:45 P
0.07
is what that code shows
sorry. i thought so too!!
tony
-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:45 PM
To: CF-Talk
Subject: RE: numberformat
#DecimalFormat(MyNum/100)#
That will display 7 as .07
Now, if you
#DecimalFormat(MyNum/100)#
That will display 7 as .07
Now, if you wanted to parse any passed int that would be easy enough as
well.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:25 PM
To: CF-Talk
Subject: RE: numberformat
im
: numberformat
I think what Mr. Orlini is looking for is something like this.
#numberFormat(displayNumber,'.99')#>
Now if you wanted to do this in one line, this might work and least in
CFMX
#numberFormat((7/100),'99')#>
Wow, see the problem here, apparently even though
I think what Mr. Orlini is looking for is something like this.
#numberFormat(displayNumber,'.99')#>
Now if you wanted to do this in one line, this might work and least in CFMX
#numberFormat((7/100),'99')#>
Wow, see the problem here, apparently even though
im not sure there is another way to do it..the masks
in numberformat() dont produce what you would expect, strange??
tony
-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:19 PM
To: CF-Talk
Subject: RE: numberformat
Why not use
-Talk
Subject: RE: numberformat
Why not use DecimalFormat()
Steve
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:58 PM
To: CF-Talk
Subject: RE: numberformat
Thanks Robert and all for the suggestions.
Robert O.
-Original
dpath [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:15 PM
To: CF-Talk
Subject: RE: numberformat
Should be:
For example:
7/100 = 0.07
mask (#NumberFormat(7,".99")# should output .07 (right?)
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTE
Why not use DecimalFormat()
Steve
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:58 PM
To: CF-Talk
Subject: RE: numberformat
Thanks Robert and all for the suggestions.
Robert O.
-Original Message-
From: Robert
Should be:
For example:
7/100 = 0.07
mask (#NumberFormat(7,".99")# should output .07 (right?)
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:58 PM
To: CF-Talk
Subject: RE: numberformat
that code doesnt make sense? wh
If you're using CF 5 or later you can use this function:
function maskit(myNum) {
var aNum = myNum / 100;
var newNum = numberFormat(aNum,".00");
return (replace(newNum,"0.",".");
}
Then in your code, #maskit(7)#
Strangely, on my computer, numberFormat(aNum,&
Thanks Robert and all for the suggestions.
Robert O.
-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:54 PM
To: CF-Talk
Subject: RE: numberformat
Try something like:
-Original Message-
From: Robert Orlini [mailto:[EMAIL
that code doesnt make sense? what are you trying to show here?
tony
-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:54 PM
To: CF-Talk
Subject: RE: numberformat
Try something like:
-Original Message-
From: Robert Orlini
Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:43 PM
To: CF-Talk
Subject: RE: numberformat
Thanks. How do I incorporate the / 100 into the mask. I'm new to this
and am getting errors.
Robert O.
-Original Message-
From: Tony Weeg [m
Try something like:
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:43 PM
To: CF-Talk
Subject: RE: numberformat
Thanks. How do I incorporate the / 100 into the mask. I'm new to this and am
getting errors.
Robert O.
-Ori
It DOESN'T go into the mask. Do the math, then mask the results.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 12:43 PM
To: CF-Talk
Subject: RE: numberformat
Thanks. How do I incorporate the / 100 into the mask. I
Just before you NumberFormat() it...
#NumberFormat(MyValue,mask)#
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Par
Thanks. How do I incorporate the / 100 into the mask. I'm new to this and am getting errors.
Robert O.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:37 PM
To: CF-Talk
Subject: RE: numberformat
yeah, i was about to say,
yeah, i was about to say, math.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 3:35 PM
To: CF-Talk
Subject: Re: numberformat
divide by 100 ;-)
I'm not sure you can make a 7 display as a decimal value using
masks...but dividing b
-Talk
Sent: Monday, November 17, 2003 12:17 PM
Subject: numberformat
How do I apply the numberformat mask to make a 7 view as .07?
Thanks.
Robert O.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
How do I apply the numberformat mask to make a 7 view as .07?
Thanks.
Robert O.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
sage-
From: Murat Demirci [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 1:23 PM
To: CF-Talk
Subject: How to use NumberFormat function?
I need to use NumberFormat function to display very big numbers but I
couldn't find enough information about the mask parameter.
I want to di
http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt247.jsp#1110053
-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 1:23 PM
To: CF-Talk
Subject: How to use NumberFormat function?
I need to use NumberFormat function to
I need to use NumberFormat function to display very big numbers but I
couldn't find enough information about the mask parameter.
I want to display the number 5E+017 as 50. How can I do
this?
.
You probably have to use an IIF Statement and do some like
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 9:40 AM
Subject: Another NumberFormat question - brackets for negative numbers
> Hi,
>
> I cant figure out how to use numberformat to surro
Hi,
I cant figure out how to use numberformat to surround negative numbers with
brackets. Well, I can, but if I do, it appears that I also have to
incorporate the _ or the 9 for place settings, which I do not care for. Any
ideas? If there isn't one out there, I will try to roll my own.
T
On 4/30/02, Hatton Humphrey penned:
>
>>Here's the problem: I recently added a summary report to a financial
>>calculation page. The page has been using
>>NumberFormat(tot_tot+misc_tot,"9-$999,999,999.99") for several years
>>(the application has bee
On 4/30/02, Hatton Humphrey penned:
>Here's the problem: I recently added a summary report to a financial
>calculation page. The page has been using
>NumberFormat(tot_tot+misc_tot,"9-$999,999,999.99") for several years
>(the application has been in live use since arou
Okay, this may have been asked a thousand times but I'm going to make it
1001.
When comparing the Numberformat and Decimalformat funcitons (for CF 4.x)
what is the difference when it comes to rounding and numeric accuracy?
Here's the problem: I recently added a summary report to a
OTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 7:05 PM
Subject: RE: NumberFormat() Mask
> > I need to display a column of percentages, formatted with
> > 2 digits following the decimal place and one, two, or three
> > to the left. I
> I need to display a column of percentages, formatted with
> 2 digits following the decimal place and one, two, or three
> to the left. I need numbers less than 1 formatted with a
> leading zero. I'm having a time finding anappropriate
> NumberFormat() mask to do this. I
I need to display a column of percentages, formatted with 2 digits following
the decimal place and one, two, or three to the left. I need numbers less
than 1 formatted with a leading zero. I'm having a time finding an
appropriate NumberFormat() mask to do this. I'm assuming there is
maybe: ".00"
#numberformat("#number#","00")#
-- Sam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 1:55 PM
To: CF-Talk
Subject: Oh, that damn Numberformat!!
I hate NumberFormat()
I have had similar issues when my locale was all messed up (a
mixture of windows and cf.)
Try using LSNumberFormat - see what results you get.
Neil
__
Structure your ColdFusion code with Fusebox. Get the official book at
If you are always wanting two decimal places, try #DecimalFormat(number)#
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
> I hate NumberFormat(). Can someone please help?
>
> I want my numbers to output like this:
>
> 123 =
> I hate NumberFormat(). Can someone please help?
>
> I want my numbers to output like this:
>
> 123 = 123.00
> 123.1 = 123.10
> 123.00 = 123.00
> 0 = 0.00
>
> What would be the proper mask for this? I've tried 999.00,
> but then "0" be
.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 1:54 PM
Subject: Oh, that damn Numberformat!!
I hate NumberFormat(). Can someone please help?
I want my numbers to output like this:
123 = 123.00
123.1 = 123.10
123.00 = 123.00
0 = 0.00
What would be the proper mask for this? I've tried 999.00, but
then "0" becomes ".00". I've tried 990.00, but then &
Subject: RE: NumberFormat UGH
Will that work for Income Taxes too???
> -Original Message-
> From: Justin Hansen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 19, 2002 12:48 PM
> To: CF-Talk
> Subject: RE: NumberFormat UGH
>
>
> Place curser on your "Numb
Try
#LSParseNumber()#
"Success is a journey, not a destination!!"
Doug Brown
- Original Message -
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 1:04 PM
Subject: Re: NumberFormat U
Not if you use notepad...
Howie
- Original Message -
From: "Justin Hansen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 3:47 PM
Subject: RE: NumberFormat UGH
> Place curser on your "NumberFormat"
Will that work for Income Taxes too???
> -Original Message-
> From: Justin Hansen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 19, 2002 12:48 PM
> To: CF-Talk
> Subject: RE: NumberFormat UGH
>
>
> Place curser on your "NumberFormat" and push
Been there done that, but I am either not too smart, or there is no way
around either having spaces or numbers deleted
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
> Place curser on your "NumberFormat" and push the F1 key.
> A
Just kidding I'm at a loss. There may be a UDF at http://www.cflib.org
that can help.
-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 2:48 PM
To: CF-Talk
Subject: RE: NumberFormat UGH
Place curser on your "NumberFormat"
Place curser on your "NumberFormat" and push the F1 key.
All answers shall be revealed. :)
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 2:37 PM
To: CF-Talk
Subject: NumberFormat UGH
I have searched hi and low for some e
I have searched hi and low for some explination, but am at a loss.
I have a column in the db: weight, it is a float
Values can range beyond 123445.23223 and .03322323
Is there a way to use numberformat so you can show these as they are... when
I stick .03322323 into the database, it comes out
Does SQL have something like the CF numberformat ? I need to export a large
amount of data to a text file, one of the fields is numeric and I need to
left zero fill 5 digits. In CF I would just do this:
numbefromat(myfield, "0")
I could use CFFILE but its a huge amount of d
> The first line should read:
>
> I have the NumberFormat() func formatting a number with zeros. The
> result is one integer higher than the original integer.
I'm assuming its just a bug in Cf 4.5
Do you just need to pad put the string to a set number of characters? If so
th
The first line should read:
I have the NumberFormat() func formatting a number with zeros. The
result is one integer higher than the original integer.
Thanks,
-Vinny DiDonato
AOL Handle = Vinny49
-Original Message-
From: Vinny DiDonato [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
Hello:
I have the NumberFormat() func rounding up a number. The result is one
integer higher than the original integer.
Example:
NUMBERFORMAT(5111, '')
This yields 5112 on CF 4.5.
It's supposed to print 5111.
WTF?
Is this a joke?
-Original Message-
From: Chris Maloney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 8:04 PM
To: CF-Talk
Subject: RE: ASP NumberFormat
Nathan,
At first only your newsletters made me wonder about your lack of
professionalism.
Chris
-Original Message
gt;
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 2:04 PM
Subject: RE: ASP NumberFormat
> Nathan,
> At first only your newsletters made me wonder about your lack of
> professionalism.
>
> Chris
>
> -Original Message-
> From: Nathan Sta
Nathan,
At first only your newsletters made me wonder about your lack of
professionalism.
Chris
-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:58 AM
To: CF-Talk
Subject: RE: ASP NumberFormat
Your treading on THIN ICE mentioning that
Your treading on THIN ICE mentioning that COMPETITOR...
Nathan Stanford
Senior Programmer/Analyst
[EMAIL PROTECTED]
> -Original Message-
> From: Bernd VanSkiver [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 10:23 AM
> To: CF-Talk
> Subject: OT: A
http://msdn.microsoft.com/scripting/default.htm?/scripting/vbscript/doc/vsfc
tFormatNumber.htm
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in
> Sorry about bringing ASP in to the list but am having
> troubles finding the solution and was hoping someone
> here might know the answer. I am needing a way to
> format a number in ASP similar to the CF function
> NumberFormat() Is there a function or something in
> ASP
+44 (0)207 387 8890.
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 16:23
To: CF-Talk
Subject: OT: ASP NumberFormat
Sorry about bringing ASP in to the list but am having
troubles finding the solution and was hoping someone
here might know the answer. I am needi
Sorry about bringing ASP in to the list but am having
troubles finding the solution and was hoping someone
here might know the answer. I am needing a way to
format a number in ASP similar to the CF function
NumberFormat() Is there a function or something in
ASP for this? I'm not sure i
[dot] edu
> -Original Message-
> From: stas [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 30, 2001 12:49 PM
> To: CF-Talk
> Subject: Re: NumberFormat woes
>
>
>
>
> This gives you a string though, so do any calculations before output.
>
> -
vs.4.5.2.
>
>Alexander Sicular
>Chief Technology Architect
>The Neurological Institute of New York
>Columbia University
>212.305.1318
>as867 {at} columbia [dot] edu
>
>
> > -Original Message-
> > From: stas [mailto:[EMAIL PROTECTED]]
> > Sent:
This gives you a string though, so do any calculations before output.
- Original Message -
From: "Evan Lavidor" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 11:36 AM
Subject: NumberFormat woes
I feel a little sill
7;ve tried NumberFormat(mynumber, "00"), but then I get an error if there's
a three digit number.
I've tried NumberFormat(mynumber, "999"), but that doesn't display the
single digits as two digits.
I've tried NumberFormat(mynumber, "900"), but t
We just found a ready-made solution to the same problem.
Check out Russ Michaels custom tag in the DevEx-
cf_zerokiller found at the URL:
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34775F-2830-11D4-AA
9700508B94F380&method=Full
Does the trick. Too bad NumberFormat() isn
PROTECTED]]
Sent: Thursday, April 05, 2001 12:44 PM
To: CF-Talk
Subject: RE: Numberformat question.
This isn't pretty, however it does work.
#NumberFormat(Item, "$999,999.9")#
#NumberFormat(Item, "$999,999.99")#
: RE: Numberformat question.
I've been playing with a few different masks, but anytime I set up a decimal
mask it's forcing all the places, so for example, if I have the mask set at
",9$99.", the numbers get formatted (using the examples I cited
originally) $45.9000,
> This isn't pretty, however it does work.
>
>
> #NumberFormat(Item, "$999,999.9")#
>
> #NumberFormat(Item, "$999,999.99")#
>
> #NumberFormat(Item, "$999,999.999")#
Oy, that almost merits being put into a custom tag with as many times as I'm
going to have to call it!
I had come to the conclusion that I could do something similar to this, but
was hoping that there was a way to do it dynamically within the numberformat
function. I guess there isn'
585.
What I need is $45.90, $9.99, $2.985 and $0.4585.
Hatton
> -Original Message-
> From: Tumy, Brad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:27 PM
> To: CF-Talk
> Subject: RE: Numberformat question.
>
>
> can't you output like this:
&
This isn't pretty, however it does work.
#NumberFormat(Item, "$999,999.9")#
#NumberFormat(Item, "$999,999.99")#
#NumberFormat(Item, "$999,999.999")#
can't you output like this:
$#numberformat(number,mask)#
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 11:36 AM
To: CF-Talk
Subject: Numberformat question.
I have a situation where I need to display a price with either 2, 3
do I set up the
NumberFormat to show the pricing properly when possible top-ends are up to
$999,999,999.?
TIA
Hatton
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
leading
spaces.
NumberFormat(cost_price, "___.00")
or
LTrim(NumberFormat(cost_price, "___.00"))
Jim
- Original Message -
From: "Cameron" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 9:21 PM
S
Just try this with your number format
#NUMBERFORMAT(1234.1200,'9.99')# Or if its always going to be a Money
amount #DOLLARFORMAT(1234.1200)#
Hope this helps.
Jason E Miller
Computer Consultants Unlimited
http://www.computercu.com
Brainbench Certified Cold Fusion Dev
1 - 100 of 150 matches
Mail list logo
