Excel Format Cells Not Reflecting

[Michael_de_Borja]

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.

Please advise!

Thanks!

[Michael_de_Borja]

When doing append:

The format does not reflect. But when editing the values manually it reflects the format.

[Pablito (Paweł)]

Hi @Michael_de_Borja,
If you are getting the data with use of Read Cell, Read Range or Read Column activity there is an option you could try:

[Michael_de_Borja]

Hi @Pablito!

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.

[Pablito (Paweł)]

I think this might be helpful then:

Force excel to recognize numbers as text when pasting from datatable

Hey folks, the most easy way is to have an empty excel with the name temp.xlsx and set the column formats as required in your output excel. Now simply write range your Data Table in it and rename it. for eg if you want to preserve your first col as text then in temp.xlsx set it as text and when you write the data table to it your format is preserved.

[Michael_de_Borja]

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.