How to set NumberFormat to Number with 0 decimal places

Question

The following is a VBA file in MS Access for formatting an Excel worksheet. However, it formats a number with two decimal places. How to indicate that I want 0 decimal places?

wb.Sheets(1).Range("K:AD").Formula = wb.Sheets(1).Range("K:AD").Value wb.Sheets(1).Range("K:AD").NumberFormat = "Number" 

Answer 1

  wb.Sheets(1).Range("K:AD").NumberFormat = "0"