| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listbox format | Excel Discussion (Misc queries) | |||
| format a listbox | Excel Discussion (Misc queries) | |||
| How to format listbox | Excel Programming | |||
| format a listbox | Excel Programming | |||
| listbox format... | Excel Programming | |||
Hybrid Mode
