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:351728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm