Select the cell range. Right clickFormat CEllsCustom format to

_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

--
Jacob


"bwong" wrote:

When using the comma button/icon, it also adds 2 decimal places.

Is there a way to customise this button/icon... make it default not to
include the decimal places?

Thanks
Ben


.