12-07-19 09:33 PM
13-07-19 07:09 AM
This is because Excel is parsing entered input as number
Edit the Format Cell Action of Excel VBO to :
GetWorkbook(handle,Nothing).ActiveSheet.Range(cellref).NumberFormat = format
Just converted the (cellref,cellref) to (cellref) so we can work on range and not a single cell.
Pass cellref as A:B or whichever column your data will be going into and format as '@' (without quotes) in respective data items
This will convert column A and B into 'Text' columns in excel, then you can write data to it using write collection and excel won't convert your data
16-07-19 02:51 PM
03-10-19 03:45 PM
25-10-19 09:58 PM