Question

Round up the decimals in Excel using Automation

  • 29 September 2022
  • 1 reply
  • 52 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...🙂


1 reply

Userlevel 3
Badge +7

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

 

 

 

 

 

 

 

Reply