Making numbers display as currency in lables
 

Hi everyone
I want to be able to display numbers on labels as currency. Is this
possible? Even displaying calculated results on a label with two decimal
places would be great.

Thanks and best wishes for the new year to every one

Dave

Making numbers display as currency in lables
 

Label1.Caption = Format(myNum, "£#,##0.00")

change the format to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"David S" wrote in message
...
Hi everyone
I want to be able to display numbers on labels as currency. Is this
possible? Even displaying calculated results on a label with two decimal
places would be great.

Thanks and best wishes for the new year to every one

Dave

Making numbers display as currency in lables
 

vVal = Range("A1").Value /326.4

label1.Caption = Format(vVal,"$ #,##0.00")

--
Regards,
Tom Ogilvy

David S wrote in message
...
Hi everyone
I want to be able to display numbers on labels as currency. Is this
possible? Even displaying calculated results on a label with two decimal
places would be great.

Thanks and best wishes for the new year to every one

Dave

Making numbers display as currency in lables
 

in article , David S at
wrote on 31/12/2003 4:04 PM:

Hi everyone
I want to be able to display numbers on labels as currency. Is this
possible? Even displaying calculated results on a label with two decimal
places would be great.

Thanks and best wishes for the new year to every one

Dave

Thanks Bob & Tom
I will give your suggestions a try.