I am writing macro to copy an excel sheet to another excel sheet with some modification of the data. But I have some currency and numeric field in the source excel sheets, which I need to copy as it is in the target excel sheet.
But when I copy them, the trailing zero is truncated.
Suppose, I have 420.70 in the source file, it is copied as 420.7, even though I set the type of the target column as String.
The code I used as follows -
temp = wsSource.Cells(i, j).Value
wsTarget.Cells(n, k).Value = temp
i,j,n,k are index variables.
Any suggestion is appreciated.