Hello Spike
May be just format those figures as Number and not currency (as it seems).
HTH
Cordially
Pascal

"Spike" a écrit dans le message de news:
...
I have a column of numbers as 2.119.939,50 EUR
i need to remove the EUR and sum the resultant numbers. So i use the
rigtht
and len minus 4 formula and get the expected result (without the EUR).
Then
when i try to add these up i get zero.

The only way around this is to copy and paste values only, then use the
text
to columns function, then it works.

If anyone knows a more appropriate method i will be very grateful to hear,
i
have set my regional settings to German.


--
with kind regards

Spike