Changing to a usable format - number
 

I have the following problems:

I have a "number" written as 1,000.00 - however I need to convert it
in 1.000,00 (whereby ful stop is a thousands seperator and a comma is
a decimal seperator )

the second number is written as 1,000M whereby M means 1000 therefore
the number should be equal to 1.000.000

how could i convert the numbers in useful formats?

thanks for your help

Changing to a usable format - number
 

i use ful stop as a thousands seperator and a comma as
a decimal seperator. Thet means that the number for example:
1,542.22is realy not a number because it is written in a different
format. So I cannot operate with it. Therefore I would like to know if
I can change it in a normal format, that is 1.542,22