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

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