How do I display a "full" currency in a numbers column?

Platform discussions
1

I would like to display a numbers column in a full currency format ($23.00 rather than $23). Please help!

2

Hi @CJNS :wave:

Welcome to the community!

The numbers column will display the ‘full currency’ for you unless it’s a whole number like your ‘23’. We can’t get the ‘00’ after the decimal, but if it’s not a whole number and is for example $23.15, then the full ‘$23.15’ will show.

The decimals will let you type whatever you like but will round for you to the nearest 3 places. If you really need the .00 to follow the 23, you will need to start looking at work-arounds and potentially using another column type. You can use a formula column to take the number column value and format it for example.

I’d love to better understand your use case and I’m happy to chat all things monday.com any time - give me a shout whenever you like :slight_smile:

Peta | upstream
peta@upstreamtech.io
+613 9067 5611