Problem:
I have formatted cells in a template excel file.
If I input data manually for the column, the format is reflecting.
But when using Append Range, the format does not reflect.
Given:
All negative numbers are written inside a closed parenthesis.
Thanks for the reply.
But for the data, I get it from a CSV using Read CSV then append it to an excel file with the column names and respective formatting in place.
Thanks Pablito, but this is exactly what I did. Creating a template file with all formatting in place, then writing the datatable into it. It works on other formatted columns but not just the custom one.