SOLVED

Custom Date Formats in Excel

Copper Contributor

I accidentally deleted the m/yyyy from Custom Date options in Excel on Windows v10

I have a huge workbook, so do NOT want to start over with a new install unless absolutely necessary.

4 Replies
best response confirmed by Groovy_Girl33 (Copper Contributor)
Solution

@Groovy_Girl33 Well, just add it back by typing m/yyyy in the Type: box.

Riny_van_Eekelen_0-1649597577258.png

 

OMG! Thank you so much! In order to get the "type box" to add m/yyyy I had to start with an existing option and only then did the "TYPE" box appear..
Riny, thank you so much! In order to get the "type box" to re-add m/yyyy I had to start with an existing option and only then did the "TYPE" box appear.. But it worked and saved me so much time!

@Groovy_Girl33 Piece of cake!!

1 best response

Accepted Solutions
best response confirmed by Groovy_Girl33 (Copper Contributor)
Solution

@Groovy_Girl33 Well, just add it back by typing m/yyyy in the Type: box.

Riny_van_Eekelen_0-1649597577258.png

 

View solution in original post