On 04/13/2013 07:53 AM, Tom Davies wrote:
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 :)
Tom,
If a1 has '10/30 entered the work around is to use value(a1) in any
formula that requires a1 to be a number.
________________________________
From: e-letter <[email protected]>
To: [email protected]
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: [email protected]
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
--
Jay Lozier
[email protected]
--
For unsubscribe instructions e-mail to: [email protected]
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
