[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Format of amount in label

Gert-Jan

12/19/2006 6:31:00 PM

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
2 Answers

Gert-Jan

12/19/2006 6:43:00 PM

0

Found it:

Label1.Caption = Format(Range("sheets1!G46").Value, "? #,##0.00")

"Gert-Jan" <info@cubique.nl> schreef in bericht
news:45882fad$0$8817$9ba1ec04@news.is.nl...
> 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
>
>
>
>


noreply@hotmail.com

12/19/2006 6:54:00 PM

0

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

"Gert-Jan" <info@cubique.nl> wrote in message
news:45882fad$0$8817$9ba1ec04@news.is.nl...
> 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
>
>
>