> Hello Brad, > > or FWorksheet.Range['A1','A1'].Formula := '="' + Fields[I].AsString + > '"''; > > Regards > > Flávio Maurício >
----- Original Message ----- From: "Flávio Miguel dos Santos Maurício" <[EMAIL PROTECTED]> To: "Delphi-Talk Discussion List" <[email protected]> Sent: Thursday, November 10, 2005 4:30 PM Subject: Re: Excel Automation > 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
