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 …

Hi @hansgeeroms String.Format(“{0:0.00}”, row(Columnname)) [image] This would work @hansgeeroms

Keep decimal places at 2 decimals

Palaniyappan (Forum Leader) May 13, 2019, 12:37pm 2

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

This would work @hansgeeroms

10 Likes

Two decimal

Topic		Replies	Views
Column values to 2 decimal places Academy Feedback lp_business_analyst_fnd	3	1075	May 9, 2023
Find 1 decimal place values in datatable Studio datatable , activities , question	16	2506	March 7, 2020
Two decimal Help excel , activities	5	5912	June 6, 2020
Decimal conserve Studio	16	1418	July 15, 2020
Keep Decimal Places as is when read from excel Studio studio , question , activities_panel	7	686	September 19, 2023