Can I export to .xlsx / percentage

[Hamder83]

Hi 

Is it possible to export to a excel file, in a format that excel automatically will read as percentage? Without having to set it in excel?


Kind regards

[apathetichell · Accepted solution]

In Alteryx out of the box - or using XlsxWriter/Python? https://xlsxwriter.readthedocs.io/format.html

I've never done it in XlsxWriter but it should be possible. It's not possible in standard Alteryx.

[CathyS_Slalom]

Hi @Hamder83, you can format the excel first and then use the output data tool and select Preserve Formatting on Overwrite.