Formatting date question ....

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,150
Office Version
365
Platform
Windows
That I don't understand, it should keep the dates in the YMD format. As I've never had any problems using it before, I'm not sure what to suggest.
 

ClaireS

Board Regular
Joined
Jul 29, 2013
Messages
136
You probably need to enable the Legacy Wizards first: go to File, Options, Data and tick "From Text (Legacy)".
 

Watch MrExcel Video

Forum statistics

Threads
1,090,472
Messages
5,414,737
Members
403,543
Latest member
Phx007

This Week's Hot Topics

Top