Calc adds 2 extra zeros when formating numbers to percentage

Linux using 7.4.0.3.
I have a column of numbers that I’m trying to place a percentage sign after each number.
When I do, there are two added zeros inserted after each number (not after a decimal point).

I originally copied/pasted the numbers into the column so I opened a new sheet and typed in a few numbers and got the same result when formatting to percentage.

It must be something simple? But I can’t figure it out.

Please upload your .ods type sample file here.

ODS sample sheet.ods (10.1 KB)

As you (hopefully?) know, the Value 56 expressed as percent is 5600% sofar calc is correct.
If you want to express 56% you should enter exactly »56%« into the cell for implizit Formatting, or otherwise enter »0.56« into a cell (preformattet or postformatted as %.
or otherwise »0.56« before you format the cell or »56« after %-formatting.

Uh, no I don’t/didn’t know that (and really don’t understand how 56 expressed as percent = 5600.00%). I assumed I could format a column of over 200 numbers to percentages by using the percentage format option.

of course you can…but first you need copy 100 from some Cell and paste special (ctrl shift v) into selected Cellrange and choose [x]divide

1 Like

Sorry. Crosposted with @karolus.

50% of 4 is 2, the same that 4 × 0.5. So 50% and 0.5 works similar.

As a workaround for your 200 numbers:
– Apply the percentage format
– Write 100 in a cell
– Copy the value 100 (yes, to the clipboard)
– Paste Special Ctrl+Shift+Vand choose [x] Divide
imagen

1 Like

…but you with screenshot, and teaches me new syntax: <kbd :+1:

1 Like

Excellent!! :grinning:

Thank you all for the replies, much appreciated!!!

0.56 is the same value as 56%. It’s just another notation of the same.
100 * 0.56 = 56
100 * 56% = 56
100 * 56 = 5600
100 * 5600% = 5600

2 Likes

x% is only common notation for x/100 … so 56/100 == 56% and 56 == 5600/100 == 5600%

1 Like

That’s a solution?

And why do we have to go through all that hassle and libreoffice cannot set up a system like every other program does?

I am not a programmer, nor a math guru to understand what you are talking about.
Another post said, check under language " from the field that has the desired decimal separator”. There are 200 languages, do I have the time?

Do you know what decimal separator that your language uses? A stop? or a comma?

[Edit]
Whoops! That was wrong

ExcelPercent

  1. No you are wrong. So no, not “every other program does” what you imagine. In fact, what you think is “wrong” is a long-established industry standard.
  2. Learning is good for you. Learning math, learning tools you use. Learning to check facts before writing your fantasies.

Are you a know-it-better guru?
Seems like it. After creating your account a few hours earlier and reading for three minutes, you’re in a position to make accusations against …


BTW “Sofia” comes from the ancient Greek word for “wisdom”.

1 Like

Thank you for the response
I live in Canada, therefore period is what here.
I am trying to write 2.2% but the system turns it to 2.20% when I use the keyboard, or to 220.00% when I use the libreoffice %.

The diagram you entered and deleted worked on the first example, where I added manually the % symbol. The 2.20% became 2.2% Thank you

But did not fully work with libreoffice the 250.00% became 250%

And now you feel smart because you solve my problem.
You are the one who live in fantasies.
What the heck 5600% means?
And no I do not need to know that, is not relative to my life, and is not the most important aspect in my life, in this time and age.

You are so smart Lupp

I am Greek, therefore I know very well what Sofia means. Glad to see you are familiar with that meaning as well.

What I do not know, though, is why you felt that I accused your intelligence?