Textbox linked cell - Number stored as text

Hi,

I'm trying to create a kind of a search tool (see demo attached).
The search data might be a string with text, numbers or both. To ensure that people using the tool won't find some pasting format issues I want them to use a textbox linked to a cell that formulas are using. Happens that when the textbox contains text or text and numbers everything works fine, but when the search is for numbers only, the destination cell "C3" gets the error Number stored as text, and all the results below start to show errors as well.

Does anyone knows how to solve this, please?

Hi alansidman,

Sorry, I forgot to delete it. It's doing nothing there. Please ignore it.

Originally Posted by alansidman

There is no code to analyze attached to the Search Button. Please post your code to analyze.

Thanks! That's it! It's working fine

Originally Posted by sourabhg98

Hi

Link the text box to cell C2 instead and use this formula in C3-

=IFERROR(C2+0,C2)

Check attached for reference.