Hi,
Within the output tool, I am using the take file/table name from field ouput option to dynamically output my data. I am outputting the data to a range in excel that is already formatted (ie no decimal places in accounting format). The output overrwrites my excel format. I am able to keep the formatting the same when I don't take the file/table name from field and check the 6th option "preserve formatting on overwrite". However, I need to use the take file/table name from field option. Is there a way to preserve formatting with this option?
Thanks.
The single quotes around the tab name made the difference for me getting this to preserve the format. I made the change in the formula tool.
This is the answer!