Hi
Carolan! Yes, there is a way to make a column in your table automatically add the dollar sign ($) when you type in it. Here's how you can do it:
- Select the column that you want to add the dollar sign to.
- Right-click on the selected column and choose "Format Cells" from the drop-down menu.
- In the "Format Cells" dialog box, select the "Number" tab.
- Under "Category," select "Currency."
- Choose the desired currency symbol from the drop-down menu (in this case, the dollar sign).
- Click "OK" to apply the changes.
Now, when you type in any cell in the selected column, it will automatically add the dollar sign before the number.