| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Function Output to numeric (#,###.00)
The following UDF works great except it rounds to $1,234.00 versus $1,234.56.
How can I get the pennies to show? Function SumByColor(CellColor As Integer, SumRange As Range) As Long Dim MyCell As Range Dim myTotal As Double For Each MyCell In SumRange If MyCell.Interior.ColorIndex = CellColor Then myTotal = WorksheetFunction.Sum(MyCell) + myTotal End If Next MyCell SumByColor = myTotal End Function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA - Function Output | Excel Discussion (Misc queries) | |||
| Combo Box - format output as time | Excel Discussion (Misc queries) | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| HOW CAN I SHOW OUTPUT IN FEET INCH FORMAT | New Users to Excel | |||
Threaded Mode
