try

="'"&A1

equals doublequote singlequote doublequote and A1

and formula copy that down your range, and sort over the new (helper)
column

if your numbers are differing lengths you can use the Text(A1,"000000")
on the numeric portion to give the correct view.


Moonray80 Wrote:
Is there any way to properly sort a series of numbers with an alpha
suffix?
Example:

92001
92001A
92001B
91005

I've tried to convert the numbers to text but the alpha suffix nubers
still
end up in a separate group.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486113