Round up two digits after dot in Excel

[Veselin_Ganchev]

Hello,
I have one Excel file containing only two columns. Document No and Amount.
I need to round up the Amount column to have two digits after the dot for all documents.

For example document 1 is OK, because the amount is 707.36
For document 5 is NOT OK, because the amount is 2550.7 it must be 2550.70

Thank you in advance!

[Reddy_Paluri (Omkar Reddy)]

Hi @Veselin_Ganchev,

Math.Round(Amount,2)

How to round of a decimal to the nearest value?

I have a number 129454.92. I want to round it off to 1,29,455.00. The other problem is that when I read the excel file the column containing these values are converted to string type. I will have to convert it to double. How do I do that?

Regards,
Omkar P

[Srini84 (Srinivas Kadamati)]

@Veselin_Ganchev

Check below screen

Format Value settings (The Variable should be Generic Type)

Hope this helps you

Thanks

[Veselin_Ganchev]

@Reddy_Paluri @Srini84
the problem is that the value is string type.

[Srini84 (Srinivas Kadamati)]

@Veselin_Ganchev

You can create a tmp variable with Generic Type and assign that value to Format, later you can change it to string by variable.ToString

Hope this helps

Thanks

[Veselin_Ganchev]

I believe there is no easier way. Your proposal help me to make the solution.
I’m using one generic value and number format. Thank you!