Hi :) I like my answer in conjunction with Jay's but i have a feeling that Cor's Extension (as given by Tinkerer in another thread and quoted&copied below) is better. Regards from Tom :)
Jay Lozier wrote > 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. > > -- > Jay Lozier > jslozier@ Tinkerer wrote > The extension by Cor Nouws, CT2N, "Convert Text 2 Numbers" is ideal and > quick. > Paste, then click on the icon in the toolbar and it is done. > Wherever there is a number prefixed by ' the ' will be removed. > Nothing else will be changed and your sheet looks exactly the same. > Here is the link > http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates -- View this message in context: http://nabble.documentfoundation.org/prevent-automatic-reduction-of-fractions-tp4049717p4049755.html Sent from the Users mailing list archive at Nabble.com. -- 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
