title: Update the format of an Excel file in SSIS script task
body: <p>I have an SSIS package which runs an SQL script and puts the results into an Excel file; the file at the beginning has just a header row with bolded column names.</p>
  
  <p>What I have found is that, no matter how my data is formatted in my data flow tasks, my numbers end up going into the Excel file as text.</p>
  
  <p>Could somebody please help me with a script task that will update the columns <code>O</code> and <code>P</code> to be displayed correctly as currency, with the £ symbol.</p>
  
  <p>This is how they look after SSIS imports the data:</p>
  
  <p><a href="https://i.stack.imgur.com/bDppb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bDppb.png" alt="enter image description here"></a></p>
  
  <p>This is how I require them to look:</p>
  
  <p><a href="https://i.stack.imgur.com/bKrF5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bKrF5.png" alt="enter image description here"></a></p>