| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort data on custom format
Hi !
I am exporting data from my accounting software to excel. The column in which the amount is showing is custom formatted to ''''0.00" Cr" for Credit amounts and ""0.00" Dr" for debit amounts. I want sort all debit amounts in the top of the list and Credit amounts in bottom. How can I sort the data based on custom formatting. thanks in advance. shaji |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Custom Format and Data Validation Q | Excel Worksheet Functions | |||
Threaded Mode
