If the output in Excel to specify such a line
ExcelServer.AutomationServer.Cells[k, col+1] := '01/01' Then in Excel it translates into a date.
How to make this happen?
Viktor Tomilov
5,838 3 gold marks 17 silver marks 52 bronze marks
Vahan Av Vahan Av
1,352 7 silver marks 13 bronze marks
- oneBefore this assignment, set the cell format to text. How it will be there in excel'vski - I do not remember, look at help. - alexlz
|
2 answers
Quotation before the value set try:
ExcelServer.AutomationServer.Cells[k, col+1] := '''01/01' 
Yura Ivanov Yura Ivanov
25.2k 1 golden mark 22 silver marks 52 bronze marks
- Thanks for the direction you had to put 4 quotes in front)) - Vahan Av
|
Option: before inserting to set the format of cells Text .
vikttur vikttur
5.475 3 gold marks 12 silver marks 22 bronze marks
- Too easy)) I tried to change all the same. And the correct solution is already there. - Vahan Av
- The simpler, the simpler :) And the right decisions may not be one. - vikttur
|