Round off the value

[arivazhagan_mathivan (Arivazhagan Mathivanan)]

Hi All,

I’m trying to copy table from Excel and paste it in outlook. But the values is coming with multiple decimal values ( original value 2,149,915,823 the value im getting 2149915822.5099998). I want to roundoff the value with 2 decimals and also i need comma seperaor.

[Palaniyappan (Forum Leader)]

Buddy @arivazhagan_mathivan
This worked buddy
where in_int is of type Double, assign with the excel obtained value of string type and converted to double type like this
**in_int = Convert.ToDouble(“excelvalue”.ToString)**and the format is
string.Format(“{0:n}”,in_int)

Cheers @arivazhagan_mathivan
Kindly try this and let know buddy