ExcelBanter - formatting numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formatting numbers (https://www.excelbanter.com/excel-programming/329581-formatting-numbers.html)

Paula[_4_]

formatting numbers

How can i format a number as picture "999,999,999.00" using a label in a
form?

lblData1.caption = temp

and where i put the fomratnumber??

Jim Thomlinson[_3_]

formatting numbers

lblData1.Caption = Format(99999999, "#,##0.00")

HTH

"Paula" wrote:

How can i format a number as picture "999,999,999.00" using a label in a
form?

lblData1.caption = temp

and where i put the fomratnumber??

Paula[_4_]

formatting numbers

wow, was so easy!!!
thx

"Jim Thomlinson" ha scritto nel
messaggio ...
lblData1.Caption = Format(99999999, "#,##0.00")

HTH

"Paula" wrote:

How can i format a number as picture "999,999,999.00" using a label in a
form?

lblData1.caption = temp

and where i put the fomratnumber??

All times are GMT +1. The time now is 12:17 AM.