Excel Decimal values

[mohamedafzal]

I have a Sales value as 20.123456 in DB. In the report we are displaying in the Bar graph and it is rounded off to 1 decimals. Hence it is displayed as 20.1

When the Bar Graph is exported to excel, the value displayed in the cell as 20.1.

But when clicked on the cell,the value is displayed as 20.1234561018. It is displaying extra values after 5th or 6th digits(1018) which is not available in the db.

Can anyone help why the extra numbers are coming in the excel after specified decimal places.?

Is there any option to fix this.?

[MK_QSL · Accepted solution]

Use Round function while using expression..something like below

Round(SUM(Sales),'0.01')

or

Round(SUM(Sales),'0.1')

[mohamedafzal]

Thanks Manish.

It worked...