Excel Cell's format change to "Text" using QTP

Hi,

Hope this will help you for changing cell's format to "Text" using QTP. In excel we can do it using right click on cell and change the format of general to text. Same thing using QTP, we can do it as follows.

objXL.Columns(x).ColumnWidth = 20

objXL.ActiveSheet.Range("A:A").NumberFormat = "@"

Replace “A:A” with your

Thanks,
Trupti