Show 0 in the output file

hi all,

i have a below data set, firstly i want to round to 5 decimal places, secondly, i want to see all the 0 in the .xls output file. I do not want to have truncated 0 and this value column must have 5 decimal place in the output .xls file. I've tried with reporting tool, however, the output from reporting tool will automatically generate thousand separator, which i do not want to have it as well. i know fixed decimal can produce the correct figure but when output to .xls, all the 0 behind will be truncated.

Current value

value

12.896753

10.876500

19.700000

20.121304

11.090387

Value i want to see in the .xls output file.

Value

12.89675

10.87650

19.70000

20.12130

11.09039

11.00000

Output

Preparation

Accepted answers

binu_acs

@Haokun you need it in .xls file then you have to convert the amount in string format

decima1.yxmd

JarekSkudrzyk

@Haokun I agree with @binu_acs

alternatively you can write a VBA macro in xls file to properly format numbers each time the workbook is opened. This way the Alteryx will give numerical values (without 0's at the end) but the VBA macro will change the display as needed.
If you need further details - please let me know

All comments

JarekSkudrzyk

@Haokun hi, you can create the output .xlsx file, change the formatting to display 5 decimal places, and then output the data to this file to specific range and then tick "preserve formatting":

Alternatively - you can convert the numbers to string - this will however change the data type.

@Haokun you need it in .xls file then you have to convert the amount in string format

decima1.yxmd

Haokun

@binu_acs @JarekSkudrzyk

thanks for your kind help...sorry i just got the reply from the user, she needs the output in numeric format....do you think it is possible ??

binu_acs

@Haokun I don't think it is possible because alteryx passing a string value to the .xls file.

JarekSkudrzyk

@Haokun I agree with @binu_acs

Haokun

thanks all, i think that is too troublesome to write VBA...appreciate your help.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703