| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
forcing cell format to be negative currency?
I'm copying data from one WB to another. When the value is copied to a
particular cell, that cell is always a negative currency value. Here is the code I'm using to format the cell, what can I add to force any entry to be a negative currency value? Range("B85:B86").Select With Selection.Font .Name = "Arial" .FontStyle = "Bold" .NumberFormat = "$#,##0.00_);[Red]($#,##0.00)" End With |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Format Currency Cell | Excel Worksheet Functions | |||
| How to set 2 currency format in 1 cell?? | Excel Discussion (Misc queries) | |||
| Format Currency in-cell | Excel Worksheet Functions | |||
| forcing cell format type in excel using com? | Excel Programming | |||
Threaded Mode
