ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format number as currency in label control ? (https://www.excelbanter.com/excel-programming/367463-format-number-currency-label-control.html)

Marc Gendron[_2_]

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

Jim Thomlinson

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



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

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