How do I sort in English Date format

P

Peo Sjoblom

There is no difference if you use a custom format, if it is seen as text you
would need a help
column and sort by the help column

--


Regards,


Peo Sjoblom
 
N

Niek Otten

As long as they are "real" Excel dates, just sort. How they are formatted doesn't matter.
You can check for a cell being a date by formatting as General. Today, Nov 7 2007, is 39393, the number of days since 1-1-1900.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I want to sort a worksheet which has date entered in UK Format ie dd.mm.yy
 

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

Changing language from UK to US English 0
Make Day CAPS In Custom Date Format 8
countifs criteria includes date range 4
Dcount -Date Criteria - Won´t find it - 0
date in text format as a real date 2
Count Dates? 3
Formatting templates 7
Sorting dates in Excel 0

Top