What formula do i need to drag a column/line of fractions into one of percentages?

How do i automatically turn fractions into percentages in a neighboring cell and then drag-copy the formula along a whole column/line to turn all fractions into percentages in the neighboring column/line?

For this, there is a percentage format of the number that will be copied when filling in the cells.

One column has simple fractions, fraction format. The column next to it has the percentage format. I am selecting a fraction from the first column and dragging it to the second column. Shouldn’t it appear as the equivalent percentage? Eg 4/5 turns into 80%. Correct? Instead, what i see is that 4/5 turns into 1 4/5 in the second column.

Drag while holding Ctrl, then apply Format as Percent (Ctrl+Shift+5 the 5 in the upper row of the keyboard).

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer mark → Correct answer mark) to the left of the answer that solves your question (it may take a little while until it turns green).

Many thanks for the help.

1 Like