| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minus signs after number
I have results like 54- it should be -54
but when I use & command to join them the correct way and do sum to calculate tham, it always results with a 0 Any ideas on how to get the minus on the correct side that can be used to calculate totals would be appreciated -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200602/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Minus signs after number
Dim rng as Range, cell as Range
set rng = Activesheet.UsedRange.Specialcells(xlConstants,xlT extValues) for each cell in rng if right(cell,1) = "-" then cell.Formula = cdbl(cell.Value) end if Next -- Regards, Tom Ogilvy "Crowbar via OfficeKB.com" <u15117@uwe wrote in message news:5b7a7f00ab08b@uwe... I have results like 54- it should be -54 but when I use & command to join them the correct way and do sum to calculate tham, it always results with a 0 Any ideas on how to get the minus on the correct side that can be used to calculate totals would be appreciated -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200602/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No plus or minus signs to left of subtotals | Excel Worksheet Functions | |||
| How do I get Plus and Minus signs in my additions and subtraction | New Users to Excel | |||
| MINUS SIGNS REMOVAL | New Users to Excel | |||
| strip minus signs from right to left | Excel Discussion (Misc queries) | |||
| Importing values w/trailing minus signs | Excel Discussion (Misc queries) | |||
Linear Mode
