| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort Library of Congress call numbers in Excel?
I'm looking to sort Library of Congress call numbers in Excel. The format of
the cdall numbers is: Letters Number Period Letter Number and after that, perhaps more periods, letters and numbers! The problem seems to be that if I have (sorted): C3.A40 C25.C25 C124.D45 attempting to sort them as text would list C124.D45 C25.C25 C3.A40 Which is incorrect. I've been looking at the cell formatting features, and they seem to only allow me to change how the data is displayed, not how Excel thinks about the type of data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel viewer | Setting up and Configuration of Excel | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
