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 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, 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 > > 3.3223229999999999E-2 > > Can't use decimalformat, need the multiple decimals ... numberformat either > padds too many spaces or doesn't give me enough.. > > Anyone have any good recommendations for formating variable sized numbers > with decimals? > > Thank > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector v2.0 - Commerce Builder > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists