Posted to microsoft.public.excel.programming

Gert-Jan[_3_] Gert-Jan[_3_] is offline

external usenet poster

Posts: 11

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format a dollar amount to text	Jordan	Excel Worksheet Functions	4	April 30th 10 03:08 PM
Convert the amount into a word format	Bl4ck5ilv3r	Excel Discussion (Misc queries)	1	May 23rd 09 09:54 AM
Label Format to Column Format	drakehouse	Excel Discussion (Misc queries)	3	November 14th 06 12:30 AM
Format amount in string	[email protected]	Excel Discussion (Misc queries)	2	October 13th 06 02:46 PM
format row of cells to highlight least amount	oceantravel	Excel Worksheet Functions	1	October 3rd 05 09:55 PM

All times are GMT +1. The time now is 07:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us