![]() |
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 |
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 |
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