IN EXCEL I HAVE A LIST I TRY SORT ASENDING BUT IT PUTS TRUE AFTER ZOOM
B Bernie Deitrick Apr 15, 2005 #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, 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
D Dave Peterson Apr 15, 2005 #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.
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.
