How to show only two digits after dot when number is type text?

Hey! I have list of prices type text and some of them with four digits after dot. When displaying them as a simple text how do I show only two digits after dot. So for example 17.4532 > 17.45 and 45.12 > 45.12

If you are truly using this as text and not interested in rounding, then this regex extract should work:

[0-9]+(.[0-9][0-9]?)

1 Like