# Concatenate Formula Fields with 2 decimal digits

Topic Labels: Formulas
Solved
660 11
cancel
Showing results for
Did you mean:
6 - Interface Innovator

How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits.

1 Solution

Accepted Solutions
17 - Neptune

Try this:

``````"\$" &
ROUND({Daily Fees \$}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%" ``````

Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!

11 Replies 11
18 - Pluto

Use the ROUND() function surrounding your formula like this:

`ROUND(insert the text of your formula here, 2)`
6 - Interface Innovator

Close, but not close enough 😉. The % is not correct and I would also like to show \$ sign as well as % sign. Is that possible?

18 - Pluto

Click on the formatting tab to see your formatting options.

6 - Interface Innovator

Yeah.. I checked already, it is not available

18 - Pluto

That’s because your result is not a number… it’s text. You would have to add in those symbols yourself as part of your formula.

6 - Interface Innovator

I have added symbols, but looks like \$ sign can only go in the back which is incorrect. Not sure if there is a way to put it in the front (I have tried to fiddle around and couldn't figure it out). Also, still have the same issue with % not showing correctly with the ROUND formula

18 - Pluto

Put the \$ sign at the very beginning of your formula.

6 - Interface Innovator

I have tried, but it is not taking the formula

17 - Neptune

Try this:

``````"\$" &
ROUND({Daily Fees \$}, 2) &
" / " &
ROUND({Daily Fees %} * 100, 2) &
"%" ``````

Do note that there's also ROUNDUP() and ROUNDDOWN(), so pick whichever suits your needs!