Brandon Brandon - 5 months ago 55 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"


Try the following

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

You may find help in this Article