Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

On 12 September 2013 19:44, Paul <paulsteyn1@afrihost.co.za> 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: users+unsubscribe@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