How to convert german format numbers to british format

  • Thread starter Thread starter boysie
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What Does It Mean To Be British? 3
How to Convert MBOX to PST Online? 3
Which is the best MBOX Converter Tool different formats conversion? 4
How to Export Gmail Emails to PST Format? 4
How can we convert OST to PDF file format? 1
How to Convert EML to PST? 2
An Interesting Item About Europe 1
British Gas Telephone Scam 0

Back
Top