Formatnumber is to do the opposite i.e. number to string,
The best would be FINDDECIMAL which will convert the first occurring numeric to number from the string field