title: Excel: Formatting Number - Shorten the Number / Delete Digits
body: <p>In Excel you can format numbers to meet specific need like currency or dates:</p>
  
  <p><a href="http://office.microsoft.com/en-us/excel-help/number-format-codes-HP005198679.aspx" rel="nofollow noreferrer">http://office.microsoft.com/en-us/excel-help/number-format-codes-HP005198679.aspx</a></p>
  
  <p>I read the online help and other recources but I don't find the solution for my problem:</p>
  
  <p>I have numbers that look like:</p>
  
  <pre><code>2014.13
  2014.14
  2014.15
  </code></pre>
  
  <p>or I could make them look like</p>
  
  <pre><code>201413
  201414
  201415
  </code></pre>
  
  <p>I am looking for a number format that removes the first 4 digits so that the result looks like</p>
  
  <pre><code>13
  14
  15
  </code></pre>
  
  <p>It this even possible with number format? I know how to do it with a normal formula but I need to use  the number format.</p>
  
  <p><img src="https://i.stack.imgur.com/4NQpA.png" alt="enter image description here"></p>
  
  <p><strong>Update</strong></p>
  
  <p>Thanks for the suggestions. I cannot work with cells and formulas because I use the numbers as the values for the x axes of a xy chart.</p>
  
  <p>The numbers are year + kalenderweek. But I do not want to have so long numbers as tick labels in the chart I just want to show the kalenderweek. Excel offers the possibility to format the x axes values but I cannot apply normal formulas like <code>right()</code>.</p>