Recording an checkpoint Integer variable to excel as a string?
The number in question is 0024248.. Currently using dtaSheet.Cells(tcRw,"A") = aqConvert.VarToStr(page.PolNum.innerText) Records in Excel as 24248. Jack
Forum Discussion
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").
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").
