Sometimes i need to change data that i receive under the form...
Mar 25/04 for example.
Usually i change this info into 3 column of data:
Mar is now 03 for 3rd month of the year, 25 is 25 and 04 is 2004.
Then i combine all of this to get : 2004-03-25.
Then i copy/paste value in the column to get rid of the formula.
Unfortunately, excel does not understand that this is a date yet.
If i click in the cell where the 2004-03-25 data is and then press enter...now it knows it's a date as if i just typed 2004-03-25.
Of course i can do a macro to press enter on all my cells but there must be another better way.
Can anyone help me to speed up this process ?
Mar 25/04 for example.
Usually i change this info into 3 column of data:
Mar is now 03 for 3rd month of the year, 25 is 25 and 04 is 2004.
Then i combine all of this to get : 2004-03-25.
Then i copy/paste value in the column to get rid of the formula.
Unfortunately, excel does not understand that this is a date yet.
If i click in the cell where the 2004-03-25 data is and then press enter...now it knows it's a date as if i just typed 2004-03-25.
Of course i can do a macro to press enter on all my cells but there must be another better way.
Can anyone help me to speed up this process ?
