Date and Time formatting

S

Shannon

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
 
R

Roger Govier

Hi Shannon

It sorts fine for me
ddhhmm/mmmyyyy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting of date 4
TextBox will not clear date??????????? 4
date format - excluding year 2
Date Time formatting problem 7
format number-date question 16
Date / Time problem 4
Formula to calculate someone's exact age 6
Date formatting problem 3

Top