> What happens if you open the file in Excel, select the column, then
> format it as text (as it really should be defined)...
>
> I haven't tried this but I expect that that Excel and the driver
> should handle it properly
>
> HTH
>
> Dick
I've tried formatting the cells as text, general and all sorts, even tried
inserting a row of !s to force it into text - this is no good...
I'd like to be able to force it... as the clients file is 3Mb, I want to
work with it rather than a cut down one
I've found that if you force the column to be text (be inserting only text
at the top) then it only reads the textual entries - any that Excel thinks
are numbers are ignored. This means that it's an either/or situation - in
other words... no use at all!
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
