Get excel output with data type as 'Text' instead of 'General'

[hf14]

I have an excel having all General format. I want it to be having the format as 'Text'. 

How do I convert it in alteryx. How do I create a template with specific format or datatype and then append the data as it to it.

In is my input file

out is my desired output format file (.xls) 

[cjaneczko]

You cant. The best way to do it would be to setup the template in excel and then have Alteryx populate the template and preserve the formatting upon output. But if your columns are dynamic and change its going to be come trickier. 

You can convert an entire column in excel to Text by using the Text to Columns in Excel if that is the only thing you are looking to do with the file. 

[Manoj_k]

1. Connect the appropriate input tool based on your file format.
2. Use the Formula tool to convert desired columns to "Text" format.
3. Use either the Dynamic Format tool (recommended for finer control) or the Append tool with a template to define the formats and append data.
4. Connect the final tool to an Output Data tool to save the results.