We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2021-04-30 21:58:11 +0200

TF8009 gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2021-05-02 03:30:36 +0200

LeroyG gravatar image

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 markCorrect answer mark) to the left of the answer that solves your question (it may take a little while until it turns green).

edit flag offensive delete link more


Many thanks for the help.

TF8009 gravatar imageTF8009 ( 2021-05-05 20:23:41 +0200 )edit

You're welcome.

LeroyG gravatar imageLeroyG ( 2021-05-05 22:12:18 +0200 )edit

answered 2021-04-30 22:21:04 +0200

eeigor gravatar image

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

edit flag offensive delete link more


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

TF8009 gravatar imageTF8009 ( 2021-05-02 00:37:39 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-04-30 21:58:11 +0200

Seen: 41 times

Last updated: May 02