Sort Dates....again

K

K

Thanks for your advice Frank, but it didn't work.

Original Query:
I have an Excel list of dates that vary in their format
and include
EU style - dd mm yyyy
US style - mm dd yyyy
some have time too - 02/20/2002 09:22:52:953
I want to produce a standard output (mm dd yyyy) and sort
the list.
Changing the formatting using Format Cells Number Date
(or
custom) does not work. The cells are currently formatted
using this method but the output in the cells has not
changed.

Frank suggested the following - but it didn't help. If
you remove the final set of digits from the cell (i.e. the
953) then it is instantly recognised as a date/time cell.

sounds like your dates are actually not stored as dates.
Try the following:
- copy an empty cell
- select your dates
- goto 'Edit - Paste Special' and choose 'Add'

no try changing the format again. This procedure should
convert the text values to real date values
 
P

Peo Sjoblom

1. Don't mix different date formats since one type will be text or wrong
depending on the
regional setting

2. Anything that looks like this 09:22:52:953 will always be text


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 

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

Top