Unfortunately, CF is interpreting as a number. I've tried to use ISNUMERIC and it bombs on certain letter/number combinations.... if I use numberformat with other entries in this table which cf says isnumeric, it bombs with the formating.
At 11:26 AM 12/15/2004, you wrote: > > I'm having an issue where I need to have CF display the > > number 081509615D00 instead of the Scientific Notation > > 1.20307E+11 > >Well, the first value isn't a number, is it? I think you can display numbers >without scientific notation using the NumberFormat function. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187750 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
