excel - How to Convert a Float String to Number? -


A1 is formatted as text and in the decimal number I want to convert the program into a number.

"Convert the number" function (N) works only with the whole number apparently.

Trying a trick like = A1 + 0 similarly only work with whole numbers.

function use

  value (A1)   

Convert a string to a number.

Comments