Convert Excel Text Number String to Number for calculating used

//Convert Excel Text Number String to Number for calculating used

I am sure you experience after export from some software. The number treated as String. And you can’t use it for doing calculation.

  1. Copy the data to new sheet or new workbook.
  2. paste in this formular `=IF(ISBLANK(B2),””,VALUE(B2))`
    What this formular do is first check is the cell is it blank or not, if it is blank then show it is blank, else, show the value of that cell (this is the part convert it from string to number)
  3. Next, you just copy and paste the formula accordingly.
  4. Final step, you select all the formular area, then paste it as VALUE.
  5. DONE!

Below example, as you can see the yellow part is original data, it mixed with string and number. The little green arrow on the top left corner indicate you can convert it to other format, but you have to do it one by one.

On the green part is followed by formular converted it to number.

 

Thanks for reading!

By |2018-01-08T22:53:14+00:00January 8th, 2018|Computers and Internet|0 Comments

Leave A Comment