Thanks In Advance,
i need help for amount print in excel
Like my amount field value is 120.20 but in excel its showing 120.2
I did below codes but it didn't work for me:
in message box value coming properly but in excel trailing 0 is not showing please help
Thanks & Regards
Just Got Solution By running Macro
' Macro1 Macro
ActiveCell.FormulaR1C1 = "120.2"
Selection.NumberFormat = "0.00"
So after reading this code i saw highlighted code line of above code
so just added this line below to printing code line and issue resolved.
xlWorkSheet.Range('d'+ FORMAT(J)).NumberFormat := '#,##0.00';