Number format in data table

[agathiyanv (Agathiyan)]

I have two columns in a data table and I need to change those number formats
column 1 : 1234567891.987 - 1,234,567,891.987 and also 6.000 - 6
column 2 : 12.499-12.5 and 12.000-12

[Gokul001 (Gokul Balaji)]

Hi @agathiyanv

Check out this docs

https://docs.uipath.com/activities/docs/format-range-x

UiPath | How to change the cell or column format in Excel | Guide (datatype)

https://docs.uipath.com/studiox/docs/tutorial-formatting-cells

Regards
Gokul

[muhamed_fasil]

@agathiyanv
Welcome to UiPath community
you can use the below code in assign activity
newValue = math.Round(oldValue,2)

If any doubt please refer to the below link\

How do I round a number of 2 decimals?

At the moment I am trying to get rounded values (2 decimals) from Excel with the robot, but if I paste the values it does not round up or down. I just get the two last decimals. Does somebody know what to do?

[Shubham_Dutta]

Hi @agathiyanv ,
I have created a sample workflow for you which will help you to get your desired output please do have a look.
DecimalLQ.xaml (7.1 KB)

Thanks & Regards,
Shubham Dutta

[agathiyanv (Agathiyan)]

I have data in datatable

[Gokul001 (Gokul Balaji)]

Pass the excel file name and cell range in this activity @agathiyanv

Have you check out the Video