I generated XL it looks good, numbers are formatted with comma... every thing looks good. After generating XL, we apply increase / decrease decimals... ( Number we generated are 10 decimal places, In XL we display with out decimals..... when we apply increase/ decrease decimals ... its shows exact numbers in XL... It work good, if i apply each cell level ).
I will give exampe,
1) Generate an XL.
2) Select a column( top row have column names A, B,C,D... XL column names)... which select a column which shows SUM of entire column.
2.1) After selecting column click on comma style from XL header (Symbols $, %, comma style and increase decrease decimal symbols)) its an image looks like " , " ... next to this image increase and decrease decimal ....
I'm attaching image... In my image I select column B...named as Amount. I marked header symbols with blue circle...