Decimal problem in uipath

Help Forum
,
1

I want to keep only 1 number after decimal for column “price” and 2 number after decimal for column “volume”
tp.xlsx (8.1 KB)

2

@sshitol,

Use Format Cells activity for this. Use format Custom and format “0.0” for Price and “0.00” for Volume

3

Hi, @sshitol

Use format number like:

The image shows a software interface with a Format Number activity in the settings, including properties for input number, decimal places, separators, and rounding options. (Captioned by AI)
The image shows a software interface with a Format Number activity in the settings, including properties for input number, decimal places, separators, and rounding options. (Captioned by AI)1100×383 30.1 KB

4

Hi @sshitol

To solve the decimal problem in UiPath:

For the “price” column (1 decimal place):

Use the Math.Round(price, 1) function.

For the “volume” column (2 decimal places):

Use the Math.Round(volume, 2) function.

These functions round values ​​to the desired number of decimal places. Apply these operations inside a loop that goes through the rows of your Excel or DataTable table.