title: Setting format as percent in a cell using Google Sheets API
body: <p>I'm trying to set a percent format when I create a cell, this is my code. </p>
  
  <pre><code>new Data.CellData
  {
      UserEnteredValue = new Data.ExtendedValue
      {
          FormulaValue = "=(B2/C2)-1"
      },
      EffectiveFormat = new Data.CellFormat
      {
          NumberFormat = new Data.NumberFormat
          {
              Pattern = "00.0%",
              Type =  "NUMBER"
          }
      }
  }
  </code></pre>
  
  <p>Current value shown is "-0.2488570834" and I need this "-24.88%". What I'm missing ?</p>
  
  <p>Thanks in advance.</p>