When dealing with financial data in Google Sheets, it's important to present your sums in a clear and understandable manner. One way to do this is by adding the dollar sign to your sums. This not only makes your data more readable but also makes it easier to understand the units of measurement. Here's how you can do it:

Google Sheets automatically adjusts the format of your cell based on the content. However, it doesn't automatically add a dollar sign to your sums. To add a dollar sign, you'll need to format your cells manually. Let's dive into the steps:

Formatting a Single Cell
If you want to add a dollar sign to a single cell, follow these steps:

1. Select the cell you want to format.
2. Right-click on the cell and select 'Format' from the drop-down menu.

3. Choose 'Number' from the sub-menu that appears. This will open the 'Format number' pane on the right side of your screen.
Using the Custom Number Format Option
You can use the 'Custom Number Format' option to add a dollar sign to your sums. Here's how:

4. In the 'Format number' pane, under the 'Category' list, select 'Custom number format'.
5. In the 'Format' box, type '$#,##0' (without quotes) and press 'Enter'. This will apply the USD format to your sum.
Using the Currency Option

Google Sheets also provides a built-in 'Currency' option to add a dollar sign to your sums. Here's how:
6. Instead of 'Custom number format', select 'Currency' from the 'Category' list.









7. The 'Format number' pane will update to show various currency options. Select the 'USD' option, and your sum will now have a dollar sign.
Formatting a Range of Cells
If you want to add a dollar sign to a range of cells, instead of doing it one by one, you can use the 'Format as table' option. Here's how:
1. Select the range of cells you want to format.
2. Right-click on any of the selected cells and choose 'Format' from the drop-down menu.
3. This time, instead of going to 'Number', pick 'Format as table' from the sub-menu.
Using the Currency Column Type
You can use the 'Currency' column type to add a dollar sign to your sums. Here's how:
4. In the 'Format as table' pane, under the 'Create a table starting at' section, click on the icon that looks like aenserter next to 'Columns A:'. This will open the 'Create table' dialog box.
5. Click on 'Advanced', which is located at the bottom of the dialog box. This will open the 'Advanced' tab in the 'Create table' dialog box.
6. Under the 'Data type' list, choose 'Currency'. Your sums will now have a dollar sign.