SamuraiJackContributor15 years agoRecording an checkpoint Integer variable to excel as a string?The number in question is 0024248.. Currently usingdtaSheet.Cells(tcRw,"A") = aqConvert.VarToStr(page.PolNum.innerText)Records in Excel as 24248.Jack
1 ReplyReplies sorted by Most LikedSort ByMost LikedOldestNewestYMinaevStaff15 years agoHi 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").
YMinaevStaff15 years agoHi 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").
Related ContentCheckpointXML CheckpointHow to change value to variable in "Edit Property Checkpoint"?Checkpoint-like feature for Equalityhow to use a variable name in checkpoint?
Recent DiscussionsKeyword Test - Click - use -1, -1 by default?How to import external node modules in TestCompleteconvert absolute path to relative pathMultiple execution of a test plan with different values from an Excel tableSearching for mapped object took too much time msg