F
FMS
Hi
I fear I may be overly optimistic here, but it's worth a shot.
I've got a column in a spreadsheet that has a mix of currencies with the
display showing the currency letter from Number Formatting eg
USD 2200
EUR 3000
KES 5500
USD 2500
I'd love to be able to filter and show only the USD items but, even though
the currency letters show in the custom filter drop downs, it's not showing
anything when I try begins with USD.
I need to perform calcs from these items and hence can't use text and I also
can't use separate columns for each currency.
Is there anyway to filter on number formatting?
many thanks
FMS
I fear I may be overly optimistic here, but it's worth a shot.
I've got a column in a spreadsheet that has a mix of currencies with the
display showing the currency letter from Number Formatting eg
USD 2200
EUR 3000
KES 5500
USD 2500
I'd love to be able to filter and show only the USD items but, even though
the currency letters show in the custom filter drop downs, it's not showing
anything when I try begins with USD.
I need to perform calcs from these items and hence can't use text and I also
can't use separate columns for each currency.
Is there anyway to filter on number formatting?
many thanks
FMS