Converting a thing into a number

[diegosened]

Hello I have a problem with a work.

I have some values (I don't know the original format) that I have to convert into a numbers but I can't to that. I tried with value function, but #VALUE! error appear.
I tried with format cells but everything I do is useless. I tried to eliminate €, but the problems remain.

This is the excel file. Could you help me?

https://www.dropbox.com/s/h9i8wts8wk5rj0y/bozza.xlsx

[AlKey]

=VALUE(A1) works just fine:

	A	B	C	D	E	F	G	H	I
1	€2,420.00	€0.00	€2,420.00	€0.00	€0.00	€0.00	€0.00	€0.00	€0.00
2	2420	0	2420	0	0	0	0	0	0

[diegosened]

That's very strange. Could it be something related with the excel settings?

https://www.dropbox.com/s/7kbwbwf6l9vozi1/Untitled.gif

[diegosened]

uhm it could be possible that the problem is related to the decimal and thousand separators?

because by exchanging manually dots and commas, like my country standards, it works!

And do you know how can I do it automatically?

[AlKey]

This should do it

=(SUBSTITUTE(A1,".",",")