Date value prob

Roc

New Member
Joined
Nov 25, 2005
Messages
32
Have imported multiple text and dates into excel from website (all info from same site). Am now trying to sort data into date order but some date info not registering as date yet others are. Cannot simply format certain cells/columns to date, does not work. Any other ideas to format all relevant data to date format for sorting?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
if formatting as a date doesn't work, then excel doesn't recognize it as a date. you can 'convert' the data to dates with the date() function.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,927
Office Version
  1. 365
Platform
  1. Windows
Try selecting the column with the 'dates' and going to Data>Text to columns...

On the 3rd step choose the format, eg DMY, the 'dates' are currently in from the dropdown in the Column data format section.

That should convert the 'dates' into true date values that can then be formatted as required.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,381
Messages
5,547,608
Members
410,802
Latest member
DataMgmtAnalyst7
Top