Hi and Good Day! Is there a way we can format a number in a column into currency type? I have a column named list price and I am adding a dollar sign. The only option I am seeing is a String Manipulation using this expression: join(“$”, string($List Price$)) but this will convert the data type to string not like in excel where is an option to format the number into currency type. Your suggestions and opinion is greatly appreciated.

Currency Format

mlauber71 November 22, 2024, 5:05am 6

If your target system is Excel you could also employ Openpyxl for formats

or the continental package

2 Likes