Regex for numerical value formatting

[jl4357]

Hi there,

I have a column (string) with various types of data, including text and numerical values. I am hoping to format the numerical values as follows - 12345.6789 to $12,345.68 - but haven't been able to get a regular expression working. I've included a sample of the values, before and after, below.

Can anyone help with creating an expression that would achieve this?

Thanks for your help!

[binuacs]

@jl4357 One way of doing this

[jl4357]

Thank you very much for this! I tried it out and it is working.

Do you know of a way to add the thousands delimiter/comma to this formatting as well?

[binuacs]

@jl4357 @Update the toString function by adding 1 after the 0.01 argument 

eg:

ToString([Field], 2,1)

[binuacs · Accepted solution]

@jl4357 

[caltang]

@binuacs lightning fast response man! 

[jl4357]

Perfect, thank you for the quick response and very helpful solution!