| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a field with Currency and Text
Is there a tip on how I can sort this out.
I have a query that outputs as such... I have another key field that sorts before this currency/text field so that the text actually comes out in order. But, is there a statement I can write... If field contains currency to sort at descending? Apples a 10.00 Apples a 20.00 Apples a 8.00 Apples b Total Apples c Available Apples d Remaining Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble sorting first by a dates field and then by a text field. | Excel Discussion (Misc queries) | |||
| How to keep leading zero without changing field to text field? | Excel Discussion (Misc queries) | |||
| specifying currency together with a number in a single field | Excel Worksheet Functions | |||
| How do I format currency field in Excel 2000 w/o 2 extra zeroes? | Excel Discussion (Misc queries) | |||
| Pence field to currency? | Excel Worksheet Functions | |||
![simplymidori[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
