How to remove decimal value in a column?

hi guys, i have a datatable in which column 3 has floating value example: 93.00, 105.00, 82.88,…etc I want rearrange this column so that if no. is 93.00 then its should change to 93 and if it 82.88 it should remain same. is there any way for that?

You could replace “.00” with “” (empty string).

Hi @kishore.shetty,

try this
newValue = math.Round(oldValue,2) -->(2 - represents the number of decimals)


Hi @kishore.shetty, Either you can replace the text or use format value or convert to number without decimals. Thanks,AK

thank you all i got it :slight_smile:

1 Like

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