Show 0 in the output file

[Haokun]

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

11

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

Value

12.89675

10.87650

19.70000

20.12130

11.09039

11.00000

[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.

[binuacs]

@Haokun 

[binuacs · Accepted solution]

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

[Haokun]

@binuacs @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 ??

[binuacs]

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

[JarekSkudrzyk · Accepted solution]

@Haokun I agree with @binuacs

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

[Haokun]

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