Have you tried building an HTML table and putting that into Excel? On 10/18/07, Dae <[EMAIL PROTECTED]> wrote: > > Is there any way to set the field type in excel when outputting to it > using > coldfusion? > > I ask this because when I have a number that has leading zeros, they get > dropped when output in excel. > > As an example lets say I have a table with name, id number. The ID > numbers > have leading zeros such as 0003732. When I output the web in a table, I > get: > Name ID > John Doe 0003732 > > When I output to excel I get: > Name ID > John Doe 3732 > > Thanks!!! > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
