On 12 September 2013 19:44, Paul <[email protected]> wrote: > I've just had the same thing. I was working on a file, and found that > the formulas I put in would only show up as formula values, instead of > results. I made sure that the option for Display > Formulas was > unchecked, as suggested below, but this did not change anything. I even > tried checking it, then unchecking it, but neither one did anything.
Make sure the cell is not formatted as text. Format -> Cells, Numbers tab, under 'Category' -- T. R. Valentine A rich heart may be under a poor coat. -- To unsubscribe 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
