ExcelBanter - What does 'floating dollar sign' mean?

The floating dollar sign in Microsoft Excel is a formatting option that allows you to display the dollar sign ($) at the end of a number, rather than at the beginning. This is useful when you are working with a table of numbers and want to make it clear that all of the values are in dollars.

To apply the floating dollar sign in Excel, you can follow these steps:

Select the cell or range of cells that you want to format.
Right-click and choose "Format Cells" from the context menu.
In the Format Cells dialog box, click on the "Number" tab.
Select "Currency" from the list of categories.
In the "Symbol" section, choose "No Symbol" from the drop-down menu.
In the "Negative Numbers" section, choose how you want negative numbers to be displayed (e.g. with parentheses or a minus sign).
Click "OK" to apply the formatting.

Once you have applied the floating dollar sign formatting, any numbers you enter into the selected cells will automatically be displayed with the dollar sign at the end.

Here's an example: Let's say you have a table of sales figures for different products, and you want to display all of the values in dollars. You could select the entire table, apply the floating dollar sign formatting, and then enter the sales figures. The resulting table would show all of the values with the dollar sign at the end, like this:

Product A: 100$
Product B: 250$
Product C: 75$

Note that the floating dollar sign is different from the regular currency symbol ($), which is typically displayed at the beginning of a number. The regular currency symbol can also be applied in Excel using the "Currency" formatting option, but it will always be displayed at the beginning of the number.