Re: [libreoffice-users] percent to whole fraction

Is there an option to convert a cell with format 'Fraction' to text?

example:

a       b       'a/b

52      297     52/297
56      302     28/151
66      311     66/311

in this third line, i want to get '28' and '151'....

i tried TEXT(C2;""), and FIND("/";C2;1),


On 26-4-2019 00:45, Remy Gauthier wrote:
> Hi,
>
> I am assuming you are using Calc. There is no formula to do this: it is
> a cell formatting accessible via Format -> Cells... -> Numbers Tab,
> then go to the "Fraction" category. There you can select the # ???/???
> format which will do what you are looking for.
>
> I hope this helps.
>
> R??my.
> Le jeudi 25 avril 2019 ?? 21:42 +0000, James a ??crit :
> > I need a formula that takes as input a percent and outputs a fraction
> > that only has whole numbers.
> > Eg.
> > 1% -> "1/100"
> > 0.5% -> "1/200"
> > 1.5% -> "3/200"

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy