Am 09.04.2015 um 13:04 schrieb Andreas Säger:
> 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.
>
>
You can format the column as text which treats new input as literal text
but without changing any existing value.
If you want numeric text with 10-digits, =TEXT(A1,"00") converts
any number in A1 into a text value of the given format. The second
argument can be any number format code you would use to format a number
in your default locale context.
Finally you would paste-special the converted numbers over the original
values.
--
To unsubscribe e-mail to: users+unsubscr...@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
