There’s two ways you get the tick mark I think:
- where the value is correct, but the format was set to Text prior to putting in the value
- where the value starts with a tick mark.
If you were to fix this manually, you would need to click in the cell to update the value. So, you may need to do this with UiPath also. I believe, however, that a Write Range to a new sheet can do this all at once.
Then, lastly, you will need to format the columns. For example, invoice columns to “00000000” and amount columns to Number.
Typically, you can do this with a Select Range followed by an alt-key combination. For amount to Number format, here is an example:
Or if you need a custom format to include commas also, then it could be like this where excelSumFormat would =
It might also be beneficial to have an array of column names that identify the amount columns to be formatted. Then, you can calculate the range using this information for the Select Range.
Hopefully, that helps.