Hi :)
Errr, you could format the cell as a text cell, perhaps just by typing in
'10/30
The ' mark lets Calc know the cell is text.
Unfortunately i think that means the 10/30 can't be used in formulas! :( Btw
Excel does the same thing jic you were wondering.
Regards from
Tom :)
From: e-letter inp...@gmail.com
To: users@global.libreoffice.org
Sent: Saturday, 13 April 2013, 12:48
Subject: [libreoffice-users] prevent automatic reduction of fractions
Readers,
Is it possible to prevent calc from automatic reduction of fractions?
For example for a cell formatted as data type 'fraction':
10/30
becomes
1/3.
How to stop this behaviour, so that '10/30' remains the values in the cell?
--
LO35
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted