Preserve Formatting writing to Excel with "Take File/Table Name From Field" output option

[qasdxx]

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. 

[JohnSackey]

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. 

[JohnSackey]

This is the answer!