ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Ecel Filtering Currency Formatted to AED (https://www.excelbanter.com/excel-discussion-misc-queries/70030-ecel-filtering-currency-formatted-aed.html)

Rayomand

Ecel Filtering Currency Formatted to AED
 
I am trying to Filter a list that has one column formatted to Currency style
AED. When I filter the list using the drop down menu for the AED column,
Excel return no values. When I type in a value I am looking for, Excel does
return those values.

I am using an Excel Currency style, why is it doing this?

Thaks
Rayomand


Ron de Bruin

Ecel Filtering Currency Formatted to AED
 
See your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rayomand" wrote in message ...
I am trying to Filter a list that has one column formatted to Currency style
AED. When I filter the list using the drop down menu for the AED column,
Excel return no values. When I type in a value I am looking for, Excel does
return those values.

I am using an Excel Currency style, why is it doing this?

Thaks
Rayomand





All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com