Date and Number Format Excel

Hi,

I have a table tool that outputs number and dates to an excel file. The problem with the date field is that theres no month/year drop down in excel and for the number field the 2 decimals don't show up in the table but only when the cell is selected. How do i reach the deisired output? is this possible?

alteryx date output :

desired output format :

alteryx number excel output (no decimals):

desired output :

Workflow

Help

Accepted answers

AngelosPachis

Hi @clarrock ,

In that table tool of yours, can you make sure that when you select the "Eur Equiv" field, the number of decimals is set to be 2 as shown below

Let me know if that worked for you.

Cheers,

Angelos

All comments

AngelosPachis

Hi @clarrock ,

May I ask, in your workflow, before the "Output Data" tool that produces that Excel file, what's the data type for the fields Value Date and Eur Equiv?

AngelosPachis

In my output, the data type for "Value Date" is set to a date and the filters drop down appearing on Excel seem to be working fine

If the data type is set to string, it makes sense for Excel to be unable to pick the different dates correctly because it's looking at the discrete values of dates.

Also, are you using a Table tool from the Reporting tool categories to output that table? I can see in the screenshots you sent attached that some lines have a different background shadings than others.

vizAlter

@clarrock - Try this method for fixing your date format issue.

The default format for date is "YYYY-MM-DD" in the Alteryx workflow, so in the end of your workflow (but just before the Output tool) you need to convert that date field into desired "mm/dd/yyyy" format then export your data through the Output tool.

Please attach your dummy records for speedy solution.

clarrock

@AngelosPachis my Workflow uses a render tool after creating a table using a table tool.

What are my options if I'm not using the regular output tool?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703