W dniu 2013-11-16 17:54, Paul pisze:
Sure. Select the cell range you want to do the substitution on (otherwise it will do find and replace on the whole sheet!), and go to "Find & Replace". In the dialog, make sure the "Current selection only" option under "Other Options" is checked. Leave the "Search for" field empty, and put a zero in the "Replace with" field, then click "Replace All". Simple.
I'm really impressed by the simplicity. It's brilliant :). Thanks for your help.
Note that for some reason, this always seems to replace the blank cells with the text string "0", I can't seem to get it to replace with an actual zero. Maybe someone else knows: is there an opposite of the apostrophe "operator", one that marks input as a number? Or some way to tell "Find & Replace" to replace with numbers instead of text?
You can try regex Find: ^.*$ Replace: & For now on the 0 should be treated as number and not a text. Regards, gordom -- 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
