title: Add leading zero to this cell content in Excel
body: <p>Suppose I have this content <code>8.XY</code> in an Excel cell. I would like to add leading zeros such that it looks like <code>0008.XY</code>. The converted value will always have 4 digits in front.</p>
  
  <p>Other examples are <code>78.XY</code> becomes <code>0078.XY</code>. <code>188.XY</code> becomes <code>0188.XY</code>. <code>1123.XY</code> remains <code>1123.XY</code>. What Excel formula can I use to achieve this?</p>