Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format of amount in label
ActiveSheet.Label1.Caption = "? " & Round(Range("sheet1!g46"),2)
seems to work for me. "Gert-Jan" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a dollar amount to text | Excel Worksheet Functions | |||
Convert the amount into a word format | Excel Discussion (Misc queries) | |||
Label Format to Column Format | Excel Discussion (Misc queries) | |||
Format amount in string | Excel Discussion (Misc queries) | |||
format row of cells to highlight least amount | Excel Worksheet Functions |