In reply to Rick Wicklin.

Hi Rick, thank you for your response.

I am already using format 10.2 so its displayed up to 2 decimal places. When I export the report to excel, in the cell the value is displayed upto 2 decimal places but in the function bar in ms excel it shows the original value which is up to 6 decimal places. I tried truncating the values by converting it into character & using substr function to show the value upto 2 decimal places but the total is always more or less than 100k. i want the value in the function bar as well to be upto 2 decimal places & the total matching to 100k.