Changing date format to custom format and maintaining data structure

[kelly mort]

I just got myself into a trap and I am looking for ways to get out.

I have entered dates as dd-mm-yy into cells in my database. I want to remove those hyphens and have something like ddmmyy. Then I noticed that whenever I remove the hyphens, it converts the new number in the cell into a different and strange date which is giving me a headache. Besides, the database is very long and will take me years to do the manual change even if it allows me.

So I wanna find out if a script can do that for me.

Thanks in advance
Kelly

 

[ParamRay]

Hello, can follow these steps:

1) Select all the cells containing dates to be reformatted;
2) On the Home tab, click the Number Format dropdown menu, and select More Number Formats (at the bottom);
3) In the Format Cells dialog, select Custom (at the bottom);
4) In the Type textbox, type "ddmmyy" (without the quotes); and
5) Click OK and you should now have the desired format for your dates.

 

[kelly mort]

Oh okay. Thanks