Within Excel itself, prefixing a numberish value with an apostrophe will make it render as a string (and be absolved from zero-trimming). Did you try that?
cheers, barneyb On 9/13/07, andy mann <[EMAIL PROTECTED]> wrote: > 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 > -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4