Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making numbers display as currency in lables
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display a loss or gain (currency) | Excel Worksheet Functions | |||
Excel Error messages when making lables | Excel Discussion (Misc queries) | |||
Failure to display currency format | Excel Discussion (Misc queries) | |||
Data labels: Making the value currency & use % in a chart? | Charts and Charting in Excel | |||
Formatting a text box to display as currency | Excel Worksheet Functions |