How to fix these dates?

danhendo888

Board Regular
Joined
Jul 15, 2019
Messages
113
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6[/FONT]


How best could I go about fixing this column so that it shows dates.
The bottom half is in text format.
Thanks all.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,310
Office Version
2013
Platform
Windows
The link suggests they are simply left aligned ?
Is there a leading apostrophe in the Text dates ?
Put this formula in col "B" and copy down....if they are a date it will return true

Code:
=LEFT(CELL("format",A1))="D"
 
Last edited:

danhendo888

Board Regular
Joined
Jul 15, 2019
Messages
113
I uploaded the spreadsheet again.

A2:A6 shows dates in MM/DD/YYYY format
A7:A9 is in DD/MM/YYYY format but Excel doesn't recognize them as dates.

When I sort, this is the output.
Looking for a way to convert column A to dates.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=EqCqDj[/FONT]
 

Forum statistics

Threads
1,085,580
Messages
5,384,560
Members
401,908
Latest member
shaanprakash

Some videos you may like

This Week's Hot Topics

Top