Excel Automation Issue

I use a lot of Excel Automation for reporting. We use 3 decimals for reporting , the issue I have is that the  3 digit is round up. How can I resolve this issue. Note that  LCY is with 3 decimals. Office XP is our Excel Version
  • You can try something like to set the format in excel (making sure that the number in navision has 3 dp)

    xlBuffer.NumberFormat := '#,##0.000;[Red](#,##0.000);';