If you are going to convert the values from a string to a number, you probably want to use double since you have decimals.
To convert from a string to a number using the python option on the field calculator: float(!MYFIELDNAME!)
Did you try changing the field format in excel from a number to a string then perform a join?
Try float(fieldName) not Float(fieldname). It's case sensative.