Value is changing before printing

[David_Singleton]

Hi David,

Sorry I couldnt get you clearly.Actually I want to delete all the comma’s(,) from the direct unit cost and add one comma(,) intead of dot(.) just before the decimal places. This is codoe is working properly, but while printing in excel it is changing to

1,34,06,002

.

Let me put it another way

You are using Lakh and Crore formatting in Excel. Why is this a problem. If anything the problem is more that Navision doesn’t use correct Indian number formatting.