First time here? Check out the FAQ!

1 | initial version |

(There is no .XLXS extension for Excels *afaik*. Do you mean .XLSX ?)

(I suppose the following will hold for Excel, but don't actually know.)

LibreOffice Calc will find a sequence of digits searched for using the Find (Ctrl+F) utility or the 'Search & Replace' tool also inside numerical values which are auto-converted for the purpose into strings basing on the decimal system. This is also the behaviour of some functions, FIND() and SEARCH() among them.

If any cell is containing a numerical value this value may be displayed in very different ways (even explicitly lying) depending on the cell format set. 'Find' and 'Search & Replace' will rely on the actual value, not on what is displayed.

**An example:** The formula contained in a cell, say B3, has calculated the value 3.141592653... (the dots standing for some additional digits). You have set a currency format for B3 and the cell may display "3.14 $" according to it. Now you are looking out for "9265" using one of the above mentioned tools. B3 will be found. The same if the cell was formatted as a 'Date-Time' **with many digits** and showing "1900-01-02 03:23:53.61".

(Depending on the setting of an option additional functions may find B3 looking for "92652 in that case.)

2 | No.2 Revision |

(There is no .XLXS extension for ~~Excels ~~Excel *afaik*. Do you mean .XLSX ?)

(I suppose the following will hold for Excel, but don't actually know.)

LibreOffice Calc will find a sequence of digits searched for using the Find (Ctrl+F) utility or the 'Search & Replace' tool also inside numerical values which are auto-converted for the purpose into strings basing on the decimal system. This is also the behaviour of some functions, FIND() and SEARCH() among them.

If any cell is containing a numerical value this value may be displayed in very different ways (even explicitly lying) depending on the cell format set. 'Find' and 'Search & Replace' will rely on the actual value, not on what is displayed.

**An example:** The formula contained in a cell, say B3, has calculated the value 3.141592653... (the dots standing for some additional digits). You have set a currency format for B3 and the cell may display "3.14 $" according to it. Now you are looking out for "9265" using one of the above mentioned tools. B3 will be found. The same if the cell was formatted as a 'Date-Time' **with many digits** and showing "1900-01-02 03:23:53.61".

(Depending on the setting of an option additional functions may find B3 looking for "92652 in that case.)

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.