Recording an checkpoint Integer variable to excel as a string?

[SamuraiJack]

The number in question is 0024248.. 



Currently using

dtaSheet.Cells(tcRw,"A") = aqConvert.VarToStr(page.PolNum.innerText)

Records in Excel as 24248.



Jack

[YMinaev]

Hi Jack,



This behavior is normal (by default). To force MS Excel not to truncate zeros, you need to set the cell format to Text by using its NumberFormat propety (cell.NumberFormat = "Text").