Correct db field settings for currency?

[Apfelstrudel]

Hello,

I have a custom field in one of my databases which contain a price. Now I want to allow the people to enter a price with or without thousand seperators and with or without cent seperator.

So far so good. I added a text field with following regex: /^\d+(,|.)?\d{0,2}$/

I can enter a a price like 3,000.11. That's good but in display view I do not see any thousand seperators.

How can I do this? I also tried the format setting "format numerically" but then the cent digits are being cut off.

And I tried to modify the custom output code of the field to:

{{if $formValue}}
{number_format(floatval($value))}
{{endif}}

... but ... nope. Didn't work!

What am I doing wrong?