Forum home » Delegate support and help forum » Microsoft Excel Training and help » SOrting by currency symbol
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
SOrting by currency symbol
Resolved · Medium Priority · Version 2003
Reply Mon 15 Feb 2010, 10:33Delegate Richard said...
Richard has attended:
Excel Intermediate course
Excel Advanced course
SOrting by currency symbol
I have a list of currency amounts.
Any in £ or Euro have the cell formatted to currency, Any in $ are formatted as general.
I want to sort the file by currency symbol but due to the difference in formatting Excel just formats by amount.
Any thoughts?
Thanks,
Rich.
For upcoming training course dates see: Pricing & availability
RE: SOrting by currency symbol
Hi Richard, thanks for your query. Couple of thoughts, you could use a linked formula to trim off the $ symbol and then reformat those cells into currencies. Alternatively, use the $ sign as a delimiter, split the cells up to separate the values out and then reformat out. Basically, you need to get the raw data out of those cells with mixed text & numbers and then use data formatting before you filter. If you have large amounts of data consider building a macro as well.
Hope this helps,
Anthony
Tue 23 Feb 2010: Automatically marked as resolved.
|