This question is not clear. The answer could be a currency indicator, usually US dollars. Or, the answer could be it indicates the cell address includes an absolute address, rather than a relative address.
floating dollar sign
It is used to signify mixed or absolute cell addresses. See the related questions below.
Yes, to assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the Currency style in the Format Cells dialog box.
Yes, to assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the Currency style in the Format Cells dialog box.
floating dollar sign
Placing the "$" at the beginning of the formatting expression will place a dollar sign immediately to the left of the output. The expression "$#0.00" guarantees that numbers will be presented for dollars and cents, including the dollar sign.
Placing the "$" at the beginning of the formatting expression will place a dollar sign immediately to the left of the output. The expression "$#0.00" guarantees that numbers will be presented for dollars and cents, including the dollar sign.
Format the cell(s) as currency and ensure the currency is set to dollars
None, the question mark comes immediately after.
In a spreadsheet or other financial statement, a fixed dollar sign always occupies the same column in the printout regardless of how many digits are in the value being displayed. A floating dollar sign is normally just to the left of the first digit of each value, so it will be in different columns depending on how many digits the value has. For example, if a value can occupy up to 10 spaces, a fixed decimal display might look like this (with "^" representing a space to make it easier to see): $^^^^1.23 $^^^45.67 but with a floating $ sign it might look like ^^^^$1.23 ^^^$45.67
Consult the style guide for the publication you're submitting to.
You typically do not leave any spaces between the dollar sign and the number that follows it. This is the standard convention for writing currency amounts.
It evolves offscreen before the episode "Grating Spaces" in which it first appears.
Format the cell(s) as currency and ensure the currency is set to dollarsThe currency format can do that. As there are many currencies in the world, in different countries where the dollar is not used, a computer can be set to use a different currency symbol and it can also be done directly in Excel. So setting the cell format to currency format doesn't always put a dollar sign before the numbers.