Hi,

I have been given a task of running a query across 45000 lines of excel to
show only numbers that are rounded to thousands. (i do not want to round
numbers, just report on existing 000's). i have no idea how to do this. i
tried using adavanced auto filter - greater than 999 and ending in 000, but
no results were returned. This is probably simple to do but i have no idea.
(also do not want to bring back numbers with 000 in middle eg 500043, just
ending in 000).
any help would be greatly appreciated,

Thanks, novice user getting frustrated.