Wrap the value up in double quotes and precede it with an equals sign ie <td>="0003732"</td>
>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!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
