tnx bb, as the visitor will be importing excel file into their acctg software, field must remain numeric...
also anyone know how to apply col width as seems to default to 48px tnx again >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 > > > >-- >Barney Boisvert >[EMAIL PROTECTED] >http://www.barneyb.com/ > >Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4