title: How to change Format of a Cell to Text using VBA
body: <p>I have a &quot;duration&quot; column in an Excel sheet. Its cell format always changes — I want convert the duration from minutes to seconds, but because of the cell formatting it always gives me different answers.</p>
  <p>I was thinking that before doing the conversion I could convert that cell format to text so that it will consider that as text value and not try to auto-format it.</p>
  <p>Currently I am copying all data into Notepad and then saving it back to the Excel sheet to remove all of the previous format. Is there a way to automate setting a cell's formatting to text using VBA?</p>