Try outputing the number already formatted:
#NumberFormat(YourNumberVariable,'_99,999,999')#

HTH,
Stephen


> I have a page where I allow users to download an excel file of the
> query they have done.  I use the <CFCONTENT
> TYPE="application/vnd.ms-excel"> and it works nicely except for one
> field.  It's a 12 digit number that shows in the excel file in
> exponential notation (i.e 446547798380 is 4.46548E+11).  It doesn't
> matter if it's text instead of a number.  Any suggestions on how to
> fix this?
> 
> ---
> Sandi Benditt
> Sr. Programmer Analyst - Advanced Technologies
> DecisionOne
> 
> 
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to