ss:Position=Left ss:LineStyle=Continuous ss:Weight=1
ss:Color=#00/
Border ss:Position=Right ss:LineStyle=Continuous ss:Weight=1
ss:Color=#00/
Border ss:Position=Top ss:LineStyle=Continuous ss:Weight=1
ss:Color=#00/
/Borders
NumberFormat ss:Format=#,##0
##,0 doesn't work?
-Original Message-
From: fun and learning funandlrnn...@gmail.com
Sent: Tuesday, August 09, 2011 3:18 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Using excel NumberFormat in coldfusion
Hi All -
As suggested by a couple of coldfusion developers a weeks ago
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
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.
Any help would
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 -
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
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.
Any help would be great
cfgridcolumn name=Value numberformat=_-_,___,___.00 does not work
Normally in a table this works: #LSNumberFormat(SumInv,_-_,___,___.__)#
it will display as : 4,100.00 which is correct.
But when in a cgfrid
cfgridcolumn name=Invoice_Value numberformat=_-_,___,___.00
but it displays in the grid
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
cfgridcolumn name=Invoice_Value numberformat=_-_,___,___.00
but it displays in the grid
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.
I have this line of code:
cfgridcolumn name=TotalMoneySpent header=Total $ Spent On Election
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 entered as 22369.22
Try setting type to currency.
ie:
cfgridcolumn name=TotalMoneySpent header=Total $ Spent On Election
numberformat=$__.__ type=currency
I have this line of code:
cfgridcolumn name=TotalMoneySpent header=Total $ Spent On Election
numberformat=$__.__
The problem is that I am not getting
(VARIABLES.someVar, 2);
VARIABLES.ImageMaxFileSize1 = #NumberFormat(VARIABLES.digit2, L.9)#mb;
/cfscript
cfoutput#VARIABLES.ImageMaxFileSize1#/cfoutput
I want the output to be 3.5mb
Thanks,
Mark
~|
Message: http
Hey Mark,
how about this:
cfscript
VARIABLES.someVar = 350;
VARIABLES.digit2 = VARIABLES.someVar / 1024 / 1024;
VARIABLES.ImageMaxFileSize1 = NumberFormat(VARIABLES.digit2, ,._)
mb;
writeOutput( VARIABLES.ImageMaxFileSize1 );
/cfscript
Mingo.
Mark Leder wrote:
What am I
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:
cfscript
VARIABLES.someVar = 350;
VARIABLES.digit2
cfscript
VARIABLES.someVar = 350;
VARIABLES.digit2 = VARIABLES.someVar / 1024 / 1024;
VARIABLES.ImageMaxFileSize1 =
NumberFormat(VARIABLES.digit2, ,._) mb;
writeOutput( VARIABLES.ImageMaxFileSize1 ); /cfscript
Wouldn't
cfscript
variables.someVar = '350';
writeOutput
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 the database as 73.6. I
would like to format
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 shoshould
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.
#numberformat(n*100,repeatstring
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)thats stored
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 zeroes. 6 of one 1/2 doz. of the
other
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 would... I used repeatString(0,12
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.
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 those cases
to show up
You can use...
cfset myNumber = round(myNumber * 100)/100
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
.
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 those cases
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
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 features
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]
, 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]
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 by 100
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, math
Just before you NumberFormat() it...
cfset MyValue = MyValue/100
#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
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'm new to this and
am
Try something like:
cfset dividByHundred = (#NumberFormat(yourVar,.99)#/100)
-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
zero??
anyone??
tony
-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.
-Original
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:
cfset dividByHundred = (#NumberFormat(yourVar
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:
cfset dividByHundred = (#NumberFormat(yourVar,.99)#/100
If you're using CF 5 or later you can use this function:
cfscript
function maskit(myNum) {
var aNum = myNum / 100;
var newNum = numberFormat(aNum,.00);
return (replace(newNum,0.,.);
}
/cfscript
Then in your code, #maskit(7)#
Strangely, on my computer, numberFormat(aNum,.00) will STILL put
Should be:
cfset dividByHundred = (#NumberFormat(yourVar,.99)#/100)
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
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
nahh...the quotes around divideByHundred are not necessary, in fact
will throw an error.
the correct format for this bit of code would be
cfset divideByHundred = NumberFormat('0.07','.__')
but that would give you 0.07, not good.
the way i posted in my previous email is one way, tho'
tony
PROTECTED]
Sent: Monday, November 17, 2003 4:19 PM
To: CF-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
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
I think what Mr. Orliniis looking for is something like this.
cfset displayNumber = 7/100
cfoutput#numberFormat(displayNumber,'.99')#/cfoutput
Now if you wanted to do this in one line, this might work and least in CFMX
cfoutput#numberFormat((7/100),'99')#/cfoutput
Wow, see the problem
: numberformat
I think what Mr. Orliniis looking for is something like this.
cfset displayNumber = 7/100
cfoutput#numberFormat(displayNumber,'.99')#/cfoutput
Now if you wanted to do this in one line, this might work and least in
CFMX
cfoutput#numberFormat((7/100),'99')#/cfoutput
Wow, see the problem
: numberformat
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
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
cfset MyNum = 7
#DecimalFormat(MyNum/100)#
That will display 7 as .07
MyNum = 15
#Mid(DecimalFormat(MyNum/100),FindOneOf(DecimalFormat(MyNum/100),1)+1,Len(
DecimalFormat(MyNum/100)))#
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:47 PM
To: CF-Talk
Subject: RE: numberformat
0.07
is what that code shows
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?
.murat
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
-
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 display
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.
Thanks
You probably have to use an IIF Statement and do some like
cfset num=-10)
#IIF(num LT 0,'(#right(num,len(num)-1)#)','#num#')#
If you dont want.
#numberformat(-10,(__.__))#
Joe
- Original Message -
From: Andrew Peterson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday
:
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 around 1998). The report
that I built
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 financial
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 around 1998). The report
that I
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 12
becomes 012.00.
Arrggg!!
BTW
-
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
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
12 becomes 012.00.
How
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 = 123.00
123.1 = 123.10
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
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(). Can someone please help?
I want my
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 one,
which
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'm assuming there is one
, 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 need numbers less than 1 formatted with a
leading zero. I'm having a time finding anappropriate
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 NumberFormat and push the F1 key.
All answers
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
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 explination
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 and push the F1
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 the F1 key.
All answers shall be revealed
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.
All answers shall
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 and push the F1 key.
All answers shall be revealed
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 UGH
Not if you use notepad...
Howie
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 data
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.
However
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
then you might want
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
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 if ASP
.
-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 needing a way to
format
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
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
Your treading on THIN ICE mentioning that COMPETITOR... grin
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: ASP NumberFormat
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
[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 Stanford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:58
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 that displays the single
digits with two leading zeros.
I've tried
cfif num lte 9cfset num = 0#num#/cfif
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 silly
: NumberFormat woes
cfif num lte 9cfset num = 0#num#/cfif
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
{at} columbia [dot] edu
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 12:49 PM
To: CF-Talk
Subject: Re: NumberFormat woes
cfif num lte 9cfset num = 0#num#/cfif
This gives you a string though, so do any calculations before output
o 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: http:
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 or 4
This isn't pretty, however it does work.
CFIF Len(ListLast(Item,".")) EQ 1
#NumberFormat(Item, "$999,999.9")#
CFELSEIF Len(ListLast(Item,".")) EQ 2
#NumberFormat(Item, "$999,999.99")#
CFE
hat 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:
$#numberformat(number,mask)#
-Original Message-
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't.
Thanks
This isn't pretty, however it does work.
CFIF Len(ListLast(Item,".")) EQ 1
#NumberFormat(Item, "$999,999.9")#
CFELSEIF Len(ListLast(Item,".")) EQ 2
#NumberFormat(Item, "$999,999.99")#
CFE
: 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, $9.990
PROTECTED]]
Sent: Thursday, April 05, 2001 12:44 PM
To: CF-Talk
Subject: RE: Numberformat question.
This isn't pretty, however it does work.
CFIF Len(ListLast(Item,".")) EQ 1
#NumberFormat(Item, "$999,999.9")#
CFELSEIF Len(List
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
9700508B94F380method=Full
Does the trick. Too bad NumberFormat() isn't
Hi all,
I dunno if anyone has had this problem before, but I have been fighting with
NumberFormat for about an hour now...
I am getting a Cost Price for a product from a database which stores the
price as "Money".
So I am trying to keep things consistant remove the e
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 Developer 4.5
1 - 100 of 145 matches
Mail list logo