Harold Fuchs-4 wrote > > So, for example, if A2 is 30, A2&"0" is 300; divide by 10 gives 30 again > and > then add the 27. But if A2 is "" (empty), A2&"0" should force a numeric > zero > which stays the same when divided by 10. >
The point here is that =A2&"0" is considered text (you can check with ISTEXT), so you shouldn't even be able to divide it! There is a lack of consistency in the classification of cell contents (which is not exclusive of LO) In any case the OP wanted a blank cell not a zero (unless he hid it using Conditional Formatting as I suggested in a previous email) -- View this message in context: http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3561959.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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