experchange > excel.* > excel.programming

Crowbar via OfficeKB.com (02-06-06, 04:58 PM)
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
Tom Ogilvy (02-06-06, 05:14 PM)
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
Similar Threads