Re: [libreoffice-users] prevent automatic reduction of fractions

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 <inpost@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+help@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


--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@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