What is the in built function for converting from text to FLOAT in Excel (similar to INT())
VALUE()
Oh well. This answer is apparently too short. Is it not now?