I’m looking for a way to use uipath to change a cell’s format from general to number. I’m passing my values in as doubles but when I write them to excel, the values that should be showing up as 0 are showing as things like “-4.55E-13” and “1.36E-12”. When I manually change the cell format to “number” the values change to 0 but I need a way for my program to automatically change the cell formats for the values to show up correctly.
I’ve looked at all the other posts but can’t find something that I think would work for me. Any ideas??