Calculation Issues.

Hi All,

I am currently working on a workbook that populates various sheets inside the workbook, however i cant get my head round why something wont calculate.

Sheets
Front
Middle
Back
etc etc

So

Middle

(CELL A2)=MID(front!E16,8,5) (Which belongs to (AQ000)0.658"L") so the cell has been told to grab 0.685, in which it has and put into A2, A2 is formated as Number however the =MID(front!E16,8,5) is formated as text

(CELL A3)=3750*A2 which results in 0, when follow the formula in Evaluate Formula, it shows 3750*A2 when i step down it then shows, 3750*"0.685"

Is there anyway to calculate the 0.685 without the "" but keeping formula in A2?

Thanks in advance