Johnny Rosenberg wrote > If your cell was formatted as text, then whatever you type into that cell > will be displayed as pure text. The funny thing is that changing the > format doesn't help. You must first empty the cell, then format it as a > number, then type your formula again. You can also first format the cell > to a number format, then empty it and > finally enter your formula again.
Makes sense. Thank you (and to someone off-band)! -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy