How to convert german format numbers to british format

G

Gord Dibben

What is the difference between German and British formatting of numbers?

The comma and dot functions are reversed?

Change your Regional and Language Options in Windows.


Gord Dibben MS Excel MVP
 
R

Ron de Bruin

The comma and dot functions are reversed?

You can also use this function to make a number of the text number

With the text number in A2 you can use this

=IF(ISERR(A2*1),IF(ISERR("1.2"*1),SUBSTITUTE(SUBSTITUTE(A2,",",""),".",",")*1,SUBSTITUTE(SUBSTITUTE(A2,".",""),",",".")*1),A2*1)
 
Top