You've got a bit of a contradiction in your statements. If it MUST remain numeric, then it's a number, and you can't care about leading zeros because from a numeric perspective 123 and 0123 are identical. If you do care about the leading zeros, then you can't be dealing with a numeric context, you must be dealing with a textual (or character-based) context.
However, Excel does a pretty good job of implicit conversions, so I'd wager you can import a text column as numeric values if the data is clean (i.e. all numeric). cheers, barneyb On 9/13/07, andy mann <[EMAIL PROTECTED]> wrote: > 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 > -- 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:288450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
