How to export all rows data into one sheet?

[#1]

Hi,

I have table box with rows 290345. when I send export data to excel it is showing only 65536 rows in one sheet and next 65536 in second sheet and so on. Is there any way I can get all data in one sheet. Please can anyone suggest me.

Thanks.

[#2]

I have tried to export into csv. it is showing all rows in to one sheet. but the data which as below

534783031246360

is showing as

5.34783E+15

how to set this. can anyone suggest me please.

[awhitfield · Accepted solution]

Open the csv with something other than excel, e.g notepad or just format the column as NUMBER in excel

[JonnyPoole]

When you export to Excel, the 15 digit+ number is converted to text to show you all the digits.

But when opening from CSV, excel reads it as a number, except that excel can only keep track of 15 digit precision nubmers.

Excel Question! I don't want to use "E" or scientific notation?

Excel specifications and limits

Excel specifications and limits

... so you convert to a txt and load through the wizard into excel etc... but for excel to keep  a number this big it needs to be preserved in 'txt' format  (in the cell format options)

[#5]

Thanks.