Forum Discussion

Copper Contributor

Sep 17, 2018

Excel question about copy and pasting large amounts of data

I am attempting to convert numbers that are entered as text to numbers. The columns I am working with are large, upwards of over 500000. It seems that some data is dropped. Is there a maximum amount ...

excel

Formulas and Functions

office 365

Lorenzo Kim

Bronze Contributor

Sep 17, 2018

you may want to visit these sites:
http://excelunplugged.com/2014/05/19/15-digit-limit-in-excel/
https://www.google.com.ph/search?ei=VQafW-iOJ8ap8QXioqToDw&q=how+to+enter+20+digit+number+in+excel&oq=excel+15+digit+number+limit+issue&gs_l=psy-ab.1.1.0i71k1l8.0.0.0.416119.0.0.0.0.0.0.0.0..0.0....0...1..64.psy-ab..0.0.0....0.b5A-JU4iVpo

Michael Puterio
Copper Contributor
Sep 17, 2018
Thank you for the reply, but the large number I mean is not a single number, but the number of cells in the column. I was probably not clear on that. My sheet has close to one million cells in a column. When I attempt to copy most of the column, then paste it to another column, it appears to lose data.
- Lorenzo Kim
  Bronze Contributor
  Sep 17, 2018
  the maximum rows of a sheet is 1048576 - just a little over one million.
  if the destination column is empty - you should have no problem pasting the data in that column. if you are using manual system - there might be some problem selecting the enormous rows.