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 |
Solved! Go to Solution.
@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.
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 ??
@Haokun I don't think it is possible because alteryx passing a string value to the .xls file.
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
thanks all, i think that is too troublesome to write VBA...appreciate your help.