| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comma in number in msgbox
How would I format the the display of a msgbox to get this result:
You have $2,145.50 worth of inventory! The value 2145.5 is in the activecell, for example or in a variable, Amt. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comma in number in msgbox
Hi,
Try something like: dim strValue as string strvalue=Format( val(activecell.value), "$#,###.00") strValue= "The value " & strValue & " is in the activecell, for example or in a variable, Amt." -- Regards, Sébastien <http://www.ondemandanalysis.com "Mike H." wrote: How would I format the the display of a msgbox to get this result: You have $2,145.50 worth of inventory! The value 2145.5 is in the activecell, for example or in a variable, Amt. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comma in number in msgbox
MsgBox Application.Dollar(12345)
-- Don Guillett Microsoft MVP Excel SalesAid Software "Mike H." wrote in message ... How would I format the the display of a msgbox to get this result: You have $2,145.50 worth of inventory! The value 2145.5 is in the activecell, for example or in a variable, Amt. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I place a comma after each number in a column | Excel Discussion (Misc queries) | |||
| Inserting comma(,) after every two digits of a number from right t | Excel Worksheet Functions | |||
| Extract name before comma, space & number | Excel Discussion (Misc queries) | |||
| HOW DO I PUT 'COMMA' IN NUMBER, AS I WISH | Setting up and Configuration of Excel | |||
| using VBA in Excel it changes the dot of a number to a comma | Excel Programming | |||
Hybrid Mode
