Hello Brad,
I haved the same problem and use this solution
FWorksheet.Range['A1','A1'].Formula := '=Text(' + Fields[I].AsString + ','
"")'
Regards
Flávio Maurício
.formula
----- Original Message -----
From: "Gies,Brad" <[EMAIL PROTECTED]>
To: "Delphi-Talk Discussion List" <[email protected]>
Sent: Thursday, November 10, 2005 3:34 PM
Subject: Excel Automation
>
> I'm having an issue where a string field that I'm filling with data that
> looks like integers for the most part, is being formatted in Excel in
> scientific notation. How do I force these values to be displayed as
> strings.
>
> Below is the code used to fill the string fields. It's used in a case
> statement which checks the field type and then formats DateTimes and
> enter integers as an integer field:
>
> FWorksheet.Cells.Item[RowCount, I + 2] := Fields[I].AsString
>
> But I can't find a way to force this column or cell to be shown as a
> string.
>
>
>
> Sincerely,
>
> Brad Gies
> -------------------------------------
> NLM Software
> Southfield, MI, USA
> -------------------------------------
>
>
>
>
>
>
>
> This e-mail is intended only for the person or entity to which it is
> addressed and may
> contain confidential and/or privileged material. Any review,
> retransmission,
> dissemination or other use of, or taking of any action in reliance upon,
> this information
> by persons or entities other than the intended recipient is prohibited.
> If you
> received this message in error, please contact the sender immediately and
> delete
> the material from your computer.
> __________________________________________________
> Delphi-Talk mailing list -> [email protected]
> http://www.elists.org/mailman/listinfo/delphi-talk
>
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://www.elists.org/mailman/listinfo/delphi-talk
