Hi
See this page
http://www.contextures.com/xlautofilter02.html#Limits
You can also use my Filter Add-in to see all the numbers also
http://www.rondebruin.nl/easyfilter.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Excel Help" wrote in message ...
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