title: How to fix cell format as excel cell is losing format after executing macro
body: <p>Hi i am populating data into excel worksheet using DDE.Execute command from Oracle forms. Code is fine but when I am executing the below macro <strong>FORMAT_SECTION_TITLE_2</strong> using DDE.Execute command it colors the line but also changes the Date to number and rather value of the cell appearing as a proper date it appears as <strong>39234</strong></p>
  
  <pre><code>Sub FORMAT_SECTION_TITLE_2()
  
      With Selection.Interior
          .ColorIndex = 7
          .Pattern = xlSolid
      End With
      Selection.Font.Bold = False
  End Sub
  </code></pre>
  
  <p>I have also tried to change lots of things but no help. please suggest.</p>
  
  <p>Thanks</p>
  
  <p>Update 1:
  Siddharth I added a new sub in the excel sheet as you mentioned and my sheet name is the same as you mentioned Sheet1</p>
  
  <pre><code>Sub formatColumn()
  Sheets("Sheet1").Columns(1).NumberFormat = "dd-mmm-yy"
  End Sub
  </code></pre>