Additional Mark Found in XLS File

[zqlcancer]

I use output tool to generate an xls file. The problem is that Alteryx add an additional mark ' in front of all data which format is not a number. I have attached sample workflow here. Can anyone help to take a look and advise how to resolve this issue?

 

[Qiu]

@zqlcancer 
There is an existing thread here.

It seems the easy way is to ouput .xlsx format first then save as XLS, which is going to be phased out soon by Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Issue-with-xls-having-a-single....

[zqlcancer]

Thanks. But in some industries such as bank which still only accepts xls format. It is sad to see Alteryx cause this issue. I can understand to add a single quote in front of a number to make it as a string, but what is a point to add a single quote in front of a text value?