Hi :) Wow!! I wonder if this answers the bigger question behind what the original poster was asking. Sometimes it's difficult to "See the forest(/wood) for the trees" = If you are too close to the problem it can be difficult to get a good overview.
Anyway it looks as though this question has been resolved, perhaps inspired by the stuff i snipped from this mail. Congrats, thanks and regards from Tom :):) ________________________________ From: Regina Henschel <rb.hensc...@t-online.de> To: users@global.libreoffice.org Sent: Wed, 13 July, 2011 14:14:27 Subject: Re: [libreoffice-users] Error in Calc logical functions Hi John, <snip /> If you want a cell to only expect a number, you have to set up the cell accordingly before entering something, otherwise a cell expects all input. kind regards Regina -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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