Regional number settings

So being in mainland Europe, working with Office 360, I use the comma as my decimal point --> pi = 3,14 and not 3.14

I think my Alteryx settings are the same. In- and output with excel via "Input Data" and "Output Data" works like a charm.

However, when copying data from the Alteryx Results dialog (see screen-shot) to Excel, PI suddenly is 314.159.265.358.979

Included a few screen-shots to show what is happening.

Alteryx Screenshot.png

Result Excel.png

Bug

Accepted answers

All comments

Emmanuel_G

Hi @jvanderpol ,

Try changing the configuration, putting spaces as thousands separators and keeping commas as decimals separators.

Then you can copy your cell values in the results window with a Ctrl+C and do a Ctrl+V in the excel file as shown below.

Fais nous savoir si ça marche comme tu veux.

jvanderpol

Unfortunately no glory, copy-pasting now indeed leaves a (not-excel number format) when pasting bigger numbers into excel, but my 3,14 is still returning with the 314 trillion or so

ArtApa

Hi @jvanderpol - Would you be able to check if the PI field is a Numeric data type?

soccertil1108

additionally, what is the warning identified by the upper right red triangle in the output grid?

jvanderpol

It is a double

jvanderpol

Hello soccertil1108

jvanderpol

Guess there is my answer. Would still ope in copy-pasting those it would work. Your solution probably works as well, but then it is probably easier to make an extra output file. Use the results grid for checking/ debugging, so quick references... transforming them to strings to be able to look does not really help then. But appreciate the suggestion / help... solution probably is to change my regional settings for my full computer

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703