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!!!
