Oldest to Newest must be a 2007 function.

I am not familiar with it.

I still believe you do not have real dates but perhaps 2007 treats these
differently than earlier versions.


Gord

On Fri, 16 Jan 2009 16:04:00 -0800, pete5440
wrote:

If my numbers are "text" why are my sort options "Oldest to Newest" and not
"A-Z"? This sounds like the simpler method but how do I let excel know this
is (supposed to be) text?