Board index » delphi » Force cells in Excel to use Text format rather than Number format

2004-06-14 06:45:20 PM
delphi161
Dear All,
How does one force cells in Excel to use Text format rather than Number
format?
In my code below, if (say) aString is a numerical string (e.g. '417895240')
and if the Excel column width is small, the cell value will display as 4E+08
rather than as 417895240 ...
i.e. the NumberFormat := '@'; seems not to work.
var theRange : Variant;
...
theRange := VarArrayOf([aString, bString, cString]);
Excel.Range[Format('A%u',[i]),Excel.Cells.Item[i,varArrayHighBound(theRange,
1)+1]].Value := theRange;
Excel.Range[Format('A%u',[i]),Excel.Cells.Item[i,varArrayHighBound(theRange,
1)+1]].NumberFormat := '@';
Regards,
AndrewFG
 

<<Andrew Fiddian-Green:
How does one force cells in Excel to use Text format rather
than Number format?
--
Deborah Pate (TeamB) delphi-jedi.org
TeamB don't see posts sent via Google or ISPs
Use the real Borland server: newsgroups.borland.com
www.borland.com/newsgroups/genl_faqs.html
 

Dear Deborah,
Do you mean the following?
theRange := VarArrayOf([''''+aString, ''''+bString, ''''+cString]);
Regards,
AndrewFG
"Deborah Pate (TeamB)" <XXXX@XXXXX.COM>wrote in
message news:XXXX@XXXXX.COM...

Andrew Fiddian-Green writes:
... Joe
Member of the UK Borland User Group
 

AndrewFG
"Joe Griffin" <XXXX@XXXXX.COM>writes