Substitute text (or replace)

[cereal_killer]

Hi!

The field contains this amont in this format: 33.078.50 and I need to convert it to 33078.50 or 33,078.50

I tried Substitute ( amount; "."; "") but this gives me 3307850

Can someone give me a hand?

[Lee Smith]

33.078.50 is not a number, it is text.

[cereal_killer]

Well, it is actually a number field, but it looks that the data stored in it is text. What would be the best way to convert it?

[comment]

Assuming ALL amounts follow the same pattern, and that the periods are in the data itself (i.e. not produced by field formatting), change the field's type to Text, then try =

Substitute ( Amount ; "." ; "" ) / 100

[cereal_killer]

Thank you very much, Sir.