export from filepro to an excel file
Walter Vaughan
wvaughan at steelerubber.com
Tue Mar 14 14:31:11 PST 2006
Dennis Malen wrote:
> The only problem we have with multi and comma delimited is that if we
> are transferring a number such as "37.50" excel picks up the number as
> "37.5". If we send "37.00" excel shows it as "37".
>
> We know that we can go into excel after the file is created and reformat
> the column as a decimal. Time is money and we don't want to have to do
> this.
>
> Does anyone know of any way to overcome this problem.
Then flip the problem around. Have your spreadsheet request the information for
preformatted cells rather than pushing the data.
I can think of half a dozen ways to do it. What'll be easiest/cheapest is
another story. Heck for all I know one of Mark's onegate type programs could work.
--
Walter
More information about the Filepro-list
mailing list