Output to Excel Percents and Currency Formats

Hello,

I am currently updating data in an Excel sheet.

I would to format a column as a percent and another column as currency in Excel. I have noticed if I use a fixed decimal Alteryx does correctly format the cell.

How can I do this from within Alteryx?

Thanks,

Michael

Output

Accepted answers

DavidP

The other thing that I've seen people do is to build a VBA macro in Excel to fix all the formatting and trigger it with the Run Batch Command tool or After Run Event at the end of an Alteryx workflow.

All comments

DavidP

So you can use a Select tool just before your Output Data tool to change the data types of your required fields to fixed decimal with the format 19.2

Also, in Alteryx 2020.1 and later, you have the Option in the Output Data tool to preserve the cell formatting set in the Excel file when overwriting a range or sheet. This means that if you're writing to an existing Excel file, you can preset the cell, column or row formatting in the Excel file before running the workflow. Alteryx will then overwrite the data but keep the formatting unchanged.

mstoler

Hello,

Thank You.

I need to append so I am not sure if Preserve Formatting on Overwrite Range will work with an Append.

I did find the Select helpful.

Thanks,

Michael

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703