Thread: Format of amount in label
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gert-Jan[_3_] Gert-Jan[_3_] is offline
external usenet poster
  
Posts: 11
Default Format of amount in label
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



Reply With QuoteReply With Quote