excel - Remove decimal by VBA from a cell in Excel 2010

Question

I wrote a code by VBA for removing decimal from a cell (A22) But it doesn't work.

Range("A22").Text = Format(Range("A22").Text, "#,###,###,##0")

may something is wrong. Any idea is welcome.

标签： excelvba

Answer 1

尝试这个

Range("A1").Value = Format(Range("A1").Text, "#,###,###,##0")