answersLogoWhite

0

What is a Fixed dollar sign?

Updated: 4/28/2022
User Avatar

Wiki User

13y ago

Best Answer

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

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a Fixed dollar sign?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is a dollar sign that is displayed to the far left of a cell in excel a floating or fixed dollar sign?

fixed


What dollar sign displays to the far left in a cell?

fixed


How do you insert a floating dollar sign?

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).


What displays numbers with a fixed dollar sign to the left of the number?

Currency style format


Does floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces?

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.


Does the negative sign come before or after the dollar sign?

Does the negative sign come before or after the dollar sign?The negative sign comes before the dollar sign.


What is the dollar sign used for?

money --> ([dollar] sign) <--


Can you see an Indonesian dollar sign now?

Indonesia's currency does not have a dollar sign.


What is a dollar sign?

$ it is American dollar currency


What is the sign for dollar?

$


What does the dollar sign look like?

The dollar sign is this: $An S with a vertical line through the center


Does the dollar sign have one or two lines through it?

A dollar sign has TWO lines going through it. The one on your keyboard IS NOT the dollar sign, it is another symbol called an "OFFSET" .