Making numbers display as currency in lables

D

David S

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
 
B

Bob Phillips

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)
 
D

David S

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
Click to expand...
Thanks Bob & Tom
I will give your suggestions a try.
 
Top