autofilter/formatting problem

[mick.whyte]

Hi

Very strange. I am working on a CSV and want to run an autofilter on a
column. For some reason the column (currently formatted as one
currency) won't allow changes to formatting or return any values on
the autofilter. Sheet is not protected nor is any error thrown, just
doesn't change formatting or find matching records.

Any help appreciated

Mick

 

[Earl Kiosterud]

Mick,

Most likely, the stuff is text, not numbers. Number formatting has no effect on text.
Imports usually bring stuff in as text. If you change the file extension to .txt, then open
it, it invokes the Text Import Wizard, where you can specify number typing for such columns.
Also look for spaces or other unprintables in the contents (try moving the cursor in the
formula bar).
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.