SOLVED

Custom Date Formats in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3281178%22%20slang%3D%22en-US%22%3ECustom%20Date%20Formats%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281178%22%20slang%3D%22en-US%22%3E%3CP%3EI%20accidentally%20deleted%20the%20m%2Fyyyy%20from%20Custom%20Date%20options%20in%20Excel%26nbsp%3B%3CSPAN%20class%3D%22%22%3Eon%20Windows%20v10%3C%2FSPAN%3E%3C!--%20%20EndFragment%20%20%20--%3E%3C%2FP%3E%3CP%3EI%20have%20a%20huge%20workbook%2C%20so%20do%20NOT%20want%20to%20start%20over%20with%20a%20new%20install%20unless%20absolutely%20necessary.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3281178%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281196%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Date%20Formats%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1358995%22%20target%3D%22_blank%22%3E%40Groovy_Girl33%3C%2FA%3E%26nbsp%3BPiece%20of%20cake!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281195%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Date%20Formats%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281195%22%20slang%3D%22en-US%22%3ERiny%2C%20thank%20you%20so%20much!%20In%20order%20to%20get%20the%20%22type%20box%22%20to%20re-add%20m%2Fyyyy%20I%20had%20to%20start%20with%20an%20existing%20option%20and%20only%20then%20did%20the%20%22TYPE%22%20box%20appear..%20But%20it%20worked%20and%20saved%20me%20so%20much%20time!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281190%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Date%20Formats%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281190%22%20slang%3D%22en-US%22%3EOMG!%20Thank%20you%20so%20much!%20In%20order%20to%20get%20the%20%22type%20box%22%20to%20add%20m%2Fyyyy%20I%20had%20to%20start%20with%20an%20existing%20option%20and%20only%20then%20did%20the%20%22TYPE%22%20box%20appear..%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281180%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Date%20Formats%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1358995%22%20target%3D%22_blank%22%3E%40Groovy_Girl33%3C%2FA%3E%26nbsp%3BWell%2C%20just%20add%20it%20back%20by%20typing%20m%2Fyyyy%20in%20the%20Type%3A%20box.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1649597577258.png%22%20style%3D%22width%3A%20434px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F362749i94C2E7BEF14EE2C2%2Fimage-dimensions%2F434x396%3Fv%3Dv2%22%20width%3D%22434%22%20height%3D%22396%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1649597577258.png%22%20alt%3D%22Riny_van_Eekelen_0-1649597577258.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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!!