List boxes actually show text not numbers. So what you want to do is to
format the numbers that you are putting in the box, not format the listbox.

Listbox1.add format(10.123456, "#,##0.00")

--
HTH...

Jim Thomlinson


"gem" wrote:

hi
i have a list box which dispalys numbers such as 10.87542 how do i format
this so it only has 2 numbers after the decimal e.g. 10.87?
thanks