Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter/formatting problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter/formatting problem
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. ----------------------------------------------------------------------- wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter problem | Excel Discussion (Misc queries) | |||
autofilter problem | New Users to Excel | |||
Problem with Autofilter | Excel Discussion (Misc queries) | |||
Autofilter problem | Excel Worksheet Functions | |||
autofilter problem | Excel Worksheet Functions |