Navigator | Tier 3

Question

Round up the decimals in Excel using Automation

Forum|Forum|3 years ago
September 29, 2022
1 reply
998 views

Hi All,

Can someone help me with this scenario. where I need to round up the decimal value in excel(51.7896 to 51.78)?

can someone post how we can achieve this scenario?

Thanks in advance...🙂

Most Valuable Pathfinder

Most Valuable Pathfinder

Hi @KOLI CHARAN ,

https://botstore.automationanywhere.com/bot/a2019-decimal-rounding-off-bot

Please use the Number package in that To string Actions

To string converts a user-specified number to a string.

Enter a number or select a predefined Number variable.
Enter the number of digits after the decimal.
To remove all the digits after the decimal, leave the default value of 0.
Assign the output to a String variable. You can use prompt-assignment during the building and testing of the bot
Please find the below screenshot

_Tamil_