ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   format listbox (https://www.excelbanter.com/excel-programming/364848-format-listbox.html)

GEM

format listbox
 
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

Jim Thomlinson

format listbox
 
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


Dave Peterson

format listbox
 
You have another response at your other post.

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


--

Dave Peterson


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com