I need to format the value in cell in whole column in excel. I do not really know how to do this.
In the report I get, the type is custom and for example 250,000.000% . After formatting I want it to be number and value of 2500.00 .
I am reading the whole column. Then I am looping this DT and reading each cell. This is the step when I am stuck, because I do not know how to format this.
Thanks, so it is weird but it looks like the value changes but the format of cell stays as percantage so nothing is changed. I would need to change format in excel cell rather than changing format of variable.
it works great but I have another quesiton. there is option to change format of one cell, once I have 1000 to change and I am looping through it, changing and saving file each time it lasts really long. Is there an option to change format of wider range?