Keep decimal places at 2 decimals

Help
1

Hi everyone,

I’m having an excel with string variables in one column (column1) with values that are like this: 7.60
When i’m opening this in a datatable via excel application scope, i’m getting 7.6 as value.
But i want to keep it as 7.60. Is there a code that i can keep my 2 decimal places in my datatable on uipath?

2 Likes
2

Hi @hansgeeroms

String.Format(“{0:0.00}”, row(Columnname))

image
image786×368 4.68 KB

This would work @hansgeeroms

10 Likes
3

While you retrieve data back from the data table, you can use the following sample codes.

String.Format("F2", dtTable.Columns("ColumnName"))
String.Format("0.00", dtTable.Columns("ColumnName"))
String.Format("0.##", dtTable.Columns("ColumnName"))
1 Like
4

Thanks! This works in my for each row activity!!!

1 Like
5

Cheers buddy keep going @hansgeeroms

1 Like
6

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