title: Can I use VBA to detect if a number is stored as text in a cell?
body: <p>I am thinking somehting along the lines of:</p>
  
  <pre><code>if Range("A1").NumberFormat = "@" AND test to show that the content of A1 can be a number Then
      Debug.Print("A1 is a number stored as text")
  end if
  </code></pre>