Ask Your Question

In Calc: How do I search for an exact number?

asked 2018-02-21 13:24:32 +0200

Astralogic gravatar image

When ~I search for 55, 556 will be highlighted because it contains 55. How do I search for an exact number?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-02-21 14:03:42 +0200

Grantler gravatar image

updated 2018-02-21 14:11:35 +0200

If (!) 55 is a defined single number in a range of numbers (no text) you can SEARCH (FIND&REPLACE function) this way (regular expressions enabled):


The ^ means "begin of paragraph", the $ means "end of paragraph".

If you want to distinguish formulae or values, so you can choose one of these options:

The Find & Replace dialog has an option to search 'Formulas', 'Values', or 'Notes'. This applies to any search, not just one using regular expressions.(source:

edit flag offensive delete link more



There's also "Entire cells" checkbox under the "Find" box in Find & Replace.

Mike Kaganski gravatar imageMike Kaganski ( 2018-02-21 14:15:00 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-21 13:24:32 +0200

Seen: 629 times

Last updated: Feb 21 '18