title: How to make sure all excel cells formatted as text in a column actually are
body: <p>I have a column of content submitted by multiple users, generally pasted into a sheet, from multiple sources. This column has numbers that should always be formatted as text.
  In fact, no matter how this is done, there are always a few items that never have the indicator in the left corner warning that these are formatted as text (which we want to see in all cases)</p>
  
  <p>Checking the individual cell, it does show as formatted text, but in reality on an import into a datatable, if the indicator is missing, the datatype is imported as a number.
  Clicking after the number and hitting Enter will change the indicator to text.</p>
  
  <p>How can I do that in VBA? I don't want to visit each cell, click on the end of the content and hit enter.Cutting and paste special in no combination reliably fixes these. </p>
  
  <p>What does excel look at, which gets the format issue right with these text format warning indicators, and yet doesn't seem to get it right when you look at the cell format properties?</p>
  
  <p><img src="https://i.stack.imgur.com/wapaL.png" alt="enter image description here"></p>
  
  <p>Excel 2003 but have had the same issue in later versions too.</p>