title: How to Add Data Validation in a Column with leading Zero
body: <p>For example I want the data in my Column A to be in 4digits whole number only.</p>
  
  <pre><code>1111
  2222
  3333
  4444
  0033
  0032
  </code></pre>
  
  <p>Now, I've added a data validation in this column, </p>
  
  <pre><code>Allow = Whole Number
  Min = 0
  Max = 9999
  </code></pre>
  
  <p>Now, What if the data contains "0" at the beginning? How can I include this value?</p>
  
  <p>Also, I've tried the formula below but it will not retain the leading zero.</p>
  
  <pre><code>=IF(LEN(A1),MOD(A1,1)=0,"")
  </code></pre>