title: Keeping leading zeros with find and replace
body: <p>I'm using Excels find and replace to remove hyphens from long numbers. They are mixed between birth dates and organisation numbers that have been filled with leading zeros to have the same number of characters. There are a LOT of numbers so find and replace seems to be the simplest solution to remove the hyphens. 
  But when i use find and replace the leading zeros are truncated and I have not found a solution to keep them afterwards. </p>
  
  <p>For example i have: </p>
  
  <pre><code>19551230-1234
  01234567-8901
  </code></pre>
  
  <p>and after find and replace I have</p>
  
  <pre><code>1,95512E+11
  12345678901
  </code></pre>
  
  <p>but want the format as:</p>
  
  <pre><code>195512301234
  012345678901
  </code></pre>
  
  <p>So I want to keep the leading zeros after find and replace. I've tried formatting the cells as text, but it doesn't work as the find and replace automatically truncates the leading zero and keeps the remaining characters, so the zero is completely removed. I am using Excel 2010, but answers for several versions are appreciated. </p>