Brandon Brandon - 2 years ago 169 Question

Adjusting number format using

I have this statement nested in an IF-Statement under a scenario. I would like it to format column 2 into a Accounting number without decimal places. How can this be done using The current code gives me ex:

on an input of
. I noticed excel has buttons for adding or subtracting decimal places. Could these be called within Thanks!

Lo.ListColumns("Column2").DataBodyRange(CurrentRow).NumberFormat = "ACCOUNTING"

Answer Source

Try the following

Lo.ListColumns("Column2").DataBodyRange(CurrentRow).NumberFormat = "#0,000.00"

You may find help in this Article

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download