CODEWITHSUNDEEP
excel
Yaakov
Yaakov

Reputation: 105

convert text to number with fraction in Excel?

I have tried with replacing the . by , and it works. I would like to make it automatic for many values but did not work out even I tried these methods given by office as you can see on the pic below with the method =VALUE(A2) showing nothing enter image description here

enter link description here

Upvotes: 0

Views: 885

Answers (1)

BigBen
BigBen

Reputation: 49998

You should be able to use NUMBERVALUE, which allows you to specify the decimal separator.

=NUMBERVALUE(A2,".")

Since I'm used to a . decimal separator, I tested with , in the text in column A:

enter image description here

Upvotes: 2

Related Questions