title: Conversion required from general in to text format in vba
body: <p>I want to convert the value of my variable valueTofind from the general into text format but below the line of code gives me an error, Kindly help me with the updated version of the code.</p>
  
  <pre><code> valuetoFind=rngfound
      valuetoFind.numberformat="@"
  </code></pre>
  
  <p>This variable value changes everytime with the new set of data.
  Thanks in advance.</p>