


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 


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 