Re: [libreoffice-users] percent to whole fraction

Let me rephrase the question.... ;)

In the 'example' line we see:

56  302    28/151

The actual cell contents are:

56 302     0,18543046357615894039735099337748

Is it possible to get the values '28' and '151' as show by the 
fraction-formatter?



On 26-4-2019 19:01, Luuk wrote:
> 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