What formula to use to add $ and comma in the field

Nathan Nguyen

I have a "run-rate" field that sums up values from 4 other cells. What formula can I add so the summed value automatically has the $ sign and comma between the numbers?

Also, can I use the same formula in the other 4 cells so that people don't have to add $ and comma when inputting data?

Thank you

Dale Murphy

@Nathan Nguyen have you tried formatting that column the way you want?

dm

Nathan Nguyen

@Dale Murphy I have looked at the column setting and formatting, but nothing will give me the $ and comma automatically after a user inputs just the number. In Excel, it does it automatically.