Format of amount in label

G

Gert-Jan

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
 
S

Stevek

ActiveSheet.Label1.Caption = "? " & Round(Range("sheet1!g46"),2)
seems to work for me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Userform label text if form is not loaded??? 3
Common format for Labels in Userform 3
.find does not find if .NumberFormat = "#,##0.00" 2
Change one label in another form 4
How to change parts of Cells().NumberFormat 5
cell values as label captions 1
Changing the text of a label on a Userform 1
Adding Label Numerical Values correctly 2

Top