Select all columns then DataSort.

Choose the column to sort on.

To input a - into a text field, F2 to edit, move the insertion point to where
you want the - and hit the - key.


Gord Dibben MS Excel MVP

On Sun, 24 Sep 2006 10:35:01 -0700, chipster
wrote:

how do I sort a worksheet based on one column?

How di I input a - into a text field