Did you try numberFormat(myNum, ",9.9")
? On 6/27/2012 1:34 PM, Richard White wrote: > I think i may need to be clearer on what i am trying to achieve: > > I have any form of number, they could be integer or floats and with varying > decimal places such as: > > 11 > 11111.111111111 > 11.11 > 1.1 > 111111111111111111111.11111111111111111111 > > etc.... > > I need to have a function that simply adds the thousand separators and > returns exactly how they were, such as: > > 11 > 11,111.111111111 > 11.11 > 1.1 > 111,111,111,111,111,111,111.11111111111111111111 > > i was hoping there was an existing function that would handle this but its > looking like i am going to have to develop a custom function that handles > this as the number either handles integers OR floats but not both? > > thanks > > > > > >> Then try >> >> numberFormat(myNum, ",9.9") >> >> thanks Jason, although this strips off all the decimals >> >>> numberFormat(myNum, ",9") >>> >>> thanks for your help Robert although that didnt work as it returns lots of >>> zeros after the decimal place. >>> >>> for example: 112221.111 got changed to 112,221.11100000000000 >>> >>> thanks >>> >>> com/austin_ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
