Picture: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??

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??
>
>
>
>

wow, was so easy!!!
thx


"Jim Thomlinson" <JimThomlinson@discussions.microsoft.com> ha scritto nel
messaggio news:9CEF84B1-DF27-4348-834E-ADDD0281E39B@microsoft.com...
> 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??
>>
>>
>>
>>