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: [email protected]
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
