Hi,
I am trying to convert "text"?? into number and I am trying to use find and replace but I get no results.
In cell X2 I have the string "133.81kWh".
In cell Y2 I have the following formula "=TRIM(LEFT(X2;LEN(X2)-3))"
I want to convert 133.81kWh to 133,81.
I have tried changing the format from text to number, I have tried to find and replace . with ,. I have also tried paste as special and multiplying the string with 1.0.
I am looking at a cell with the formula =ISNUMBER(Y2) which gives me FALSE.
How should I do to convert the string 133.81kWh to 133,81?
I am trying to convert "text"?? into number and I am trying to use find and replace but I get no results.
In cell X2 I have the string "133.81kWh".
In cell Y2 I have the following formula "=TRIM(LEFT(X2;LEN(X2)-3))"
I want to convert 133.81kWh to 133,81.
I have tried changing the format from text to number, I have tried to find and replace . with ,. I have also tried paste as special and multiplying the string with 1.0.
I am looking at a cell with the formula =ISNUMBER(Y2) which gives me FALSE.
How should I do to convert the string 133.81kWh to 133,81?
Last edited: