Trim values after decimal point


I have a column in excel which contains Amount (ex: 28976.00)

How to trim the value after decimal point?

I want only the amount 28976

Thank you in advance

We can use use this expression
str_output = Split(str_input,".")(0).tostring
where str_input = “28976.00”

1 Like

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