Ahh.... just tried it, and now I remember why I didn't like that. It displays properly, but shows a green triangle in the top left corner of every cell.
Sincerely, Brad Gies ------------------------------------- NLM Software Southfield, MI, USA ------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:delphi-talk- > [EMAIL PROTECTED] On Behalf Of Fredrik Larsson > Sent: Thursday, November 10, 2005 11:00 AM > To: 'Delphi-Talk Discussion List' > Subject: RE: Excel Automation > > Can you put a ' before the string? I think Excel interprets that as a > string > then. > > > -----Original Message----- > > 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. > > __________________________________________________ > Delphi-Talk mailing list -> [email protected] > http://www.elists.org/mailman/listinfo/delphi-talk 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
