Hi Dae! Try this for the cell in your table:
<td style="mso-number-format:\@;">0003732</td> -- Cheers! Michael David Thursday, October 18, 2007, 9:28:19 PM, you wrote: > Yup. that the way I usually do it. I build it in html then I just add a > content header to send it to Excel. > On 10/18/07, Aaron Rouse <[EMAIL PROTECTED]> wrote: >> >> 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!!! >> > >> > >> > >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
