Minus signs

[Nicolaas_Vercruyse]

Hello,

There is probably an easy way but I haven't found it yet.

I have a  table looking like this

Tax base amount	Tax
2.000,00-	420,00-
24.825,10-	5.213,27-
24.820,10	5.209,27

And I would need to get this as fixed decimals...

Any quick idea?

[caltang]

The thousand separator is a "."? 

[Nicolaas_Vercruyse]

yes

[Christina_H]

Can use this in a multifield formula:

ToNumber(REGEX_Replace([_CurrentField_],"(.*)(-)","$2$1"),0,0,",")