Results 1 to 5 of 5

Textbox linked cell - Number stored as text

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Lisbon
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 1708 (build 8431.2153)
    Posts
    62

    Question 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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Number Stored as Text
    By esaban in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2014, 03:29 PM
  2. [SOLVED] Set Format of TextBox linked cell to number/numeric Value.
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2014, 07:22 AM
  3. [SOLVED] Number Stored as text - Tried every possible way
    By muneshmeena in forum Excel General
    Replies: 4
    Last Post: 03-24-2013, 03:22 AM
  4. Replies: 1
    Last Post: 10-28-2012, 05:42 AM
  5. Replies: 8
    Last Post: 03-13-2012, 01:04 PM
  6. Number stored as text
    By Blake 7 in forum Excel General
    Replies: 2
    Last Post: 06-23-2011, 06:12 AM
  7. Number stored as text
    By Sharp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2007, 07:52 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1