Excel Write Range not copying format

[jcvsalinas (Julius Cris Salinas)]

Excel - Format column to text before writing

@mohammedamaan, I don’t think we have activities to do that, but if you have few rows of data and (I hope you are trying to write a number into fields and they are converting to some other formats ), you can directly paste the values by appending “'” , I mean (') a single quote before the data so that it will write as it is. If you have huge data, or anyway you want to change the format and you want to write the values, here is a piece of code which will help you in changing the formats Di…