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
