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
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