Excel 2013 macro code snippet:
ActiveCell.FormulaR1C1 = "=MID(D2,FIND(""."",D2,1)+1,FIND(""."",D2,FIND(""."",D2,1)+1)-FIND(""."",D2,1)-1)"
This formula within the quotes works (I'm using it in another excel file), but when the above code snippet sets the cell value, the actual resulting...