Hi Shannon

It sorts fine for me
ddhhmm/mmmyyyy

040950/May2007
041000/May2007
151500/Nov2007
011200/Dec2007

--

Regards
Roger Govier

"Shannon" wrote in message
...
Does anyone know how to make a format with a military-style date and time?
I
used
dd/hhmm/MMM/yy
so 1200 on January 1, 2008 would look like 011200JAN08, but when I go to
sort the dates/times, it always goes to the first two numbers.

Thanks,
Shannon