Thread: Reliable way to convert text to number with a formula
View Single Post
 
Old 12-22-2019, 04:47 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 866
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In your french workbook perhaps:
Code:
=IFERROR(VALUE(B3);VALUE(SUBSTITUTE(B3;".";",")))
I think the formula semicolons automatically get changed to commas if opening it in an English version of Excel.
edit:
Or perhaps:
Code:
=SIERREUR(CNUM(B3);CNUM(SUBSTITUE(B3;".";",")))
Reply With Quote