It is somewhat unclear, you can sort left to right by choosing data sort
options and left to right. the Alignment of text within cells is just a
format so change the format.

Perhaps you will have to give a little more information

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561416