Stupid Date Format not Recognized

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Select the cells containing dates, choose Data|Text to Columns and at step 3 specify DMY as the date format.

By the way, for us in the UK MDY is stupid.
 

ammdumas

Active Member
Joined
Mar 14, 2002
Messages
469
Funny. I work for a British Engineering Firm. That would explain why they like DD/MM/YY...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,388
Messages
5,547,661
Members
410,805
Latest member
Ginoji
Top