Sorting
 

I have a kist of names one of which is TRUE. When I sort the list
alpabetically this name does not sort properly. Can anyone help. I'm assuming
it's something to do with the TRUE function as the word FALSE does not sort
also. There are people with the name TRUE.

James

Sorting
 

Put a single quote in front of false. False is being intrprete as the
logical FALSE which has a number equivalent instead a string and is being
sorted by the number.

"James Spencer" wrote:

I have a kist of names one of which is TRUE. When I sort the list
alpabetically this name does not sort properly. Can anyone help. I'm assuming
it's something to do with the TRUE function as the word FALSE does not sort
also. There are people with the name TRUE.

James

Sorting
 

i think true and false not sorted ?
So put ' (single quote before that words- 'true ) and now it will
sort......



On Apr 12, 12:20*pm, James Spencer <James
wrote:
I have a kist of names one of which is TRUE. When I sort the list
alpabetically this name does not sort properly. Can anyone help. I'm assuming
it's something to do with the TRUE function as the word FALSE does not sort
also. There are people with the name TRUE.

James