Re: NumberFormat , Help
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 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. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: NumberFormat , Help
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 be (0001200) Any help would be appreciated. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: NumberFormat , Help
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(0,12))# s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212825 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: NumberFormat , Help
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 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(0,12))# s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212829 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: NumberFormat , Help
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 really. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212837 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: NumberFormat , Help
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) 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 really. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212873 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
NumberFormat , Help
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. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54