I have a large spreadsheet from a query with 13,980 rows. I have sorted the
spreadsheet so that Column D is in numerical order.

When I put on the Data Filter - Autofilter, I can only display up to 1020 of
the 6960 numbers.

I have tried reformating the cell with the Data Filter off. The actual cell
looks like a formula: ="000000000001". No matter how I reformat the cell it
continues to display the formula and I continue to display only up to 1020.

--
Excel Help