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
