Want to keep 2 zeros after decimal

Hi Community!

The bot reads an excel column - call it Amount - and the amount is $1,200,000.00 in excel. When I capture the value- Row(“Amount”).tostring it writes 1200000 and leaves out the decimals. Amount is a string value.

How can I capture the decimals?

Thank you!

@Jessica_Moseley

Try below expression.

        Cdbl(Row(“Amount”).tostring).ToString("#,##0.00")
1 Like

Works perfectly. Thank you!

1 Like

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