|I could be more precise if I saw the actual data in the cells "which had date and data in the same cell". That way I would know exactly what =MID(Bx,x,xx) was producing.|
The best I can offer with the limited details provided is this:
Let's say you start with this:
1 01/02/2012 45 =MID(B1,12,2)
C1 will display 45, but it will be the Text value 45, not the number 45. The MID function returns Text, not numbers.
Try this to force Excel to convert the Text 45 into a Number which can then be summed:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.