[libreoffice-users] Re: Calc - failing search on numbers

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: users+unsubscribe@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