| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Negative to zero code
I went in and formatted a cell to: 0;"0";0 so that all negative numbers will
be converted to zero. I have a textbox on a userform that I need to do the same thing. What code would I use? I tried this but it doesn't work: txtRemain.Value = Format(txtRemain.Value, "#,#00;""0""") Any help would be greatly appriciated. Thanks, ~Gabe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to change color of negative cell | Excel Programming | |||
| Negative number morphing to a cell code | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| code wont compare negative numbers correctly | Excel Programming | |||
| Deleting a negative sign from an amount in a list (not trailing negative) | Excel Programming | |||
Threaded Mode
