Hi,
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
Hi,
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”
This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.