I am creating an excel file in cf7 and all works well except when a part number begins with a 0 - i need the number to always have 5 digits as in 01234 or 12345.
i have tried doing a Numberformat(partnum, '00000') to no avail. can i force using "TabChar" or something? noticed the the field in the created excel file will not accept a 0 even typed in manually. thanks in advance ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
