Round up two digits after dot in Excel

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!

Hi @Veselin_Ganchev,

Math.Round(Amount,2)

Regards,
Omkar P

@Veselin_Ganchev

Check below screen

Format Value settings (The Variable should be Generic Type)

image

Hope this helps you

Thanks

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

@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

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!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.