title: How can I edit a CSV file with more than 2 million rows
body: <p>Really need some quick help with this please.</p>
  
  <p>I have a comma delimited CSV file that holds about 2 millions rows of data (a lot I know but it's the only format I can work with unfortunately). One of the rows has some numbers in it that have lots of decimal places (like 3.908651901). I need to round that entire column - all 2 million rows - to whole integers.</p>
  
  <p>The problem is that when I open it in excel it says something like "only 1 million rows shown". After more investigation I have found out that excel cannot handle more than 1 millions rows at a time.</p>
  
  <p>My question is this: If I select the whole column and round the numbers to integers will that apply to the entire 2 millions rows? Or only the 1 million showing in excel?</p>
  
  <p>Are there any other programs available that can handle 2-2.5 million rows and change the column to whole integers?</p>