Am 09.04.2015 um 12:39 schrieb ianseeks: > hi > > I've got a table of numbers of general format which i change (using > Format/Cells) to make the display of numbers less than 10 have a leading > zero. > I cannot search for "07" etc as it will not find it, it will only search for > "7" which finds me all the numbers with a "7" in it. > > How can i force the search to look for "07"? > > regards > > Ian >
Search for 7 because this is the numeric value you are after. When in doubt about the correct search string for constant numbers, have a look at the status bar. If "007", "07" and "7" should be different cell values, then you should store them as text values rather than numbers. -- 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
