Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IN EXCEL I HAVE A LIST I TRY SORT ASENDING BUT IT PUTS TRUE AFTER.
IN EXCEL I HAVE A LIST I TRY SORT ASENDING BUT IT PUTS TRUE AFTER ZOOM
|
#2
|
|||
|
|||
Disco,
To Excel, TRUE is a numeric (actually, Boolean) value: use 'True as a string, and it will sort the way that you expect. HTH, Bernie MS Excel MVP "DISCO DAVE" <DISCO wrote in message ... IN EXCEL I HAVE A LIST I TRY SORT ASENDING BUT IT PUTS TRUE AFTER ZOOM |
#3
|
|||
|
|||
Either enter the value True as 'true (with that leading apostrophe)
or preformat the cell as text, then type True. True is a boolean value--not text if you just type it in a cell formatted as General. DISCO DAVE wrote: IN EXCEL I HAVE A LIST I TRY SORT ASENDING BUT IT PUTS TRUE AFTER ZOOM -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a list of cities in US by randomize in MS Excel or . | Excel Discussion (Misc queries) | |||
How do I sort a list automatically? | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
how do i automatically sort a list | Excel Worksheet Functions |