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
Post a Comment