title: How to prevent excel from truncating numbers in a CSV file?
body: <p>The first few lines of my CSV file look like this (when viewed from Notepad++):</p>
  
  <blockquote>
    <p>Trace,Original Serial Number,New Serial number
    0000073800000000097612345678901234567890,0054,0001</p>
  </blockquote>
  
  <p>When I open this file in excel, I get this:</p>
  
  <p><img src="https://i.stack.imgur.com/RGJD3.png" alt="enter image description here"></p>
  
  <p>For some reason, excel is truncating the serial numbers and the trace number. I have tried changing the format to <code>Text</code> but that still doesn't work, as excel only sees the value up to the 6:</p>
  
  <blockquote>
    <p>7.38000000000976E+34</p>
  </blockquote>
  
  <p>If I change it to <code>Number</code>:</p>
  
  <blockquote>
    <p>73800000000097600000000000000000000.00</p>
  </blockquote>
  
  <p>What can I do? I only have 60 lines, so if I have to start over and some how recopy the text into excel I will, but I'm afraid saving it will change the format once again.</p>