Format of amount in label
Found it:
Label1.Caption = Format(Range("sheets1!G46").Value, "? #,##0.00")
"Gert-Jan" schreef in bericht
...
Hi,
This doesn't work:
Label1.Caption = "? " & Round(Range("sheets1!G46").Value, 2, NumberFormat
= "0.00")
I want the label to show a text like ? 93,44 in stead of 93,44231. Can
someone help?
Thanks in advance, Gert-Jan
|