| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format number as currency in label control ?
Hi Guys, Is it possible to format a number (say as currency) when it is displayed on a label control. I can't figure which property to use. I've read answers for text boxes but these solutions don't seem to apply to a label. Thanks in advance. Marc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format number as currency in label control ?
You can give this a try...
Label1.Caption = Format(12345.67, "$#,##0.00") -- HTH... Jim Thomlinson "Marc Gendron" wrote: Hi Guys, Is it possible to format a number (say as currency) when it is displayed on a label control. I can't figure which property to use. I've read answers for text boxes but these solutions don't seem to apply to a label. Thanks in advance. Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert number to Million Currency format | Excel Worksheet Functions | |||
| filter on currency number format | Excel Discussion (Misc queries) | |||
| wrong number, no currency format | Excel Discussion (Misc queries) | |||
| Currency Format for label in UserForm | Excel Programming | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
![Marc Gendron[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
