Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Consistent format for numbers with a percentage sign

Beantwoord
3

Opmerkingen

4 opmerkingen

  • Lars Skaar

    Hi Patricia Perren,

    Happy to help you out with this. My first initial thought is that to fix the issue of spaces between the percent values in a cell you can select the cells with percentages with a space and then go over to the right hand panel and go to the third tab that is "Value Formatting" and then scroll down until you see the "Symbol Align" drop down and choose "Right Inside". And you are able to select multiple cells, even cells that aren't next to each other by holding down control and choosing all of the cells you need to change all at once. 

    I have attached a screen shot of where that is located.

    I hope this helps! Thanks so much!

    0
  • Andrew McKenzie

    Interesting and informative Lars Skaar.

    Does anyone know if there's further documentation on the "Symbol Align" field or what exactly all the options will do? "Left" and "right" are obvious to me, and "spaced" would seem to make sense (but see below), but what does "inside" mean, for example? I can't seem to find much (any?) detailed documentation on this, and when I experiment with it, the logic or use cases aren't clear.

    Also, I notice that some selections (specifically "spaced") actually change the display of all values within a column, so the alignment of A1 and A2 in the top sheet actually changed when I set A3 to "Right spaced inside" (compare the slight difference to the bottom sheet—which seems trivial, I know, but it was jarringly unexpected when I changed the Symbol Align setting for one cell's value and all values in the column danced around a bit).

    0
  • Lars Skaar

    Hi Andrew!

    I can definitely give you some clarification on what all of the options in the "Symbol Align" fields do. You are right tho, in some instances when you choose one of the options it will change everything else in the column above and below where you changed it. Specifically if you have cells in a column with Accounting and you choose Percent in another cell in that column, it will shift all of the Accounting cells over to align the numbers together, therefore leaving essentially a gutter column within the Accounting cells. This particular behavior has been brought up in the past and remains under consideration by our engineers. And as far as the "Inside" options as you'll see below in the list I'm providing, it is generally used for when there are negative values and the parentheses are being used as well.

    • Symbol Align  — mark this to select where the percentage symbol or word is included in the value.
      • Default — the setting that has been set as the alignment in the style. Typically this is "None".
      • None — no alignment is performed; 
      • Left — the symbol is at the left side of the numeric value. Example: $152.03 The symbol will be outside the parentheses if the value is negative and Use parentheses for negatives is marked. Example: $(152.03).
      • Left inside — the symbol is at the left side of the numeric value, and will be inside the parentheses if the value is negative and Use parentheses for negatives is marked. Example: ($152.03) 
      • Right — the symbol is at the right edge of the cell, and there is a space between the number and the symbol. Example: 152.03 $
      • Right inside — the symbol is on the right side of the numeric value, and there is no space between the number and the symbol. The symbol will be inside the parentheses if the value is negative and Use parentheses for negatives is marked. Example: (152.03$)
      • Right spaced inside — the symbol is on the right side of the numeric value, and there is a space between the number and the symbol. The symbol will be inside the parentheses if the value is negative and Use parentheses for negatives is marked. Example: (152.03 $)
      • Right spaced — the symbol is on the right side of the numeric value, and there is a space between the number and the symbol. The symbol will be outside the parentheses if the value is negative and Use parentheses for negatives is marked. Example: (152.03 $)
    0
  • Andrew McKenzie

    Thanks for the comprehensive answer Lars Skaar—this all makes a lot more sense now. P.S. In your final example (right spaced), I think it would actually be (152.03) $, right?

    0

U moet u aanmelden om een opmerking te plaatsen.