It is a currency indicator. US dollars display $, EURO displays the € character, British pounds display the £ chacter, etc.
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.
fixed
floating dollar sign
Currency style format
fixed
Format the cell for Currency if you want the dollar sign to be immediately before the first number (floating dolar sign). Format the cell for Accounting if you want the dollar sign to stay to the left side of the cell no mater the length of the entry (fixed dollar sign).
currency style format
You can achieve this format using the following custom number format: "$#,##0.00". This format will display the dollar sign to the left of the number and insert commas for thousands separator.
I do not understand the question, but if you are asking, how to put a dollar sign in a cell and have it always align to the left side of the cell, then you format the cell as accounting instead of currency.
Currency format: ......$12.00 (dollar sign next to number) Accounting format: $......12.00 (dollar sign at left margin of cell)
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 signIt is used to signify mixed or absolute cell addresses. See the related questions below.
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