Home

Cant set date to DD/MM/YYYY only DD-MM-YYYY available

%3CLINGO-SUB%20id%3D%22lingo-sub-793842%22%20slang%3D%22en-US%22%3ECant%20set%20date%20to%20DD%2FMM%2FYYYY%20only%20DD-MM-YYYY%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793842%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20set%20a%20date%20to%20date%20format%20DD%2FMM%2FYYYY%20(forward%20slash)%20but%20my%20Excel%202016%20only%20shows%20this%20date%20format%20with%20a%20dash%20(-).%20If%20i%20format%20cells%20only%20date%20types%20with%20a%20dash%20are%20available.%20My%20online%20version%20shows%20a%20forward%20slash.%20How%20do%20I%20override%20or%20add%20new%20date%20format%20types%3F%20If%20i%20set%20this%20as%20custom%20or%20manually%20Excel%20always%20over%20rides%20and%20replaces%20the%20%2F%20with%20a%20-%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793938%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20set%20date%20to%20DD%2FMM%2FYYYY%20only%20DD-MM-YYYY%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793938%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388791%22%20target%3D%22_blank%22%3E%40abc12330%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPress%20Ctrl%2B1%20and%20scroll%20down%20to%20date.%20What%20is%20your%20location%20set%20to%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797248%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20set%20date%20to%20DD%2FMM%2FYYYY%20only%20DD-MM-YYYY%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELocation%20is%20set%20to%20English%20(United%20Kingdom).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797555%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20set%20date%20to%20DD%2FMM%2FYYYY%20only%20DD-MM-YYYY%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388791%22%20target%3D%22_blank%22%3E%40abc12330%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20case%20I%20do%20not%20know%20the%20answer.%20Maybe%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwill%20have%20an%20answer%20for%20you%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797700%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20set%20date%20to%20DD%2FMM%2FYYYY%20only%20DD-MM-YYYY%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388791%22%20target%3D%22_blank%22%3E%40abc12330%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20custom%20format%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126411i67055DA6C110BF3E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797723%22%20slang%3D%22en-US%22%3ERe%3A%20Cant%20set%20date%20to%20DD%2FMM%2FYYYY%20only%20DD-MM-YYYY%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388791%22%20target%3D%22_blank%22%3E%40abc12330%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20changing%20format%20for%20entire%20system%20you%20may%20Win%2BR%2C%20type%20%3CSTRONG%3Econtrol%20international%3C%2FSTRONG%3E%2C%20ok%2C%20Additional%20settings%2C%20Date%20tab%2C%20and%20here%2C%20if%20not%20available%20from%20drop-down%20list%2C%20type%20desired%20format%20and%20apply%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126415i3A1599F7698D17F7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
abc12330
New Contributor

I need to set a date to date format DD/MM/YYYY (forward slash) but my Excel 2016 only shows this date format with a dash (-). If i format cells only date types with a dash are available. My online version shows a forward slash. How do I override or add new date format types? If i set this as custom or manually Excel always over rides and replaces the / with a -

5 Replies

Hello @abc12330,

 

Press Ctrl+1 and scroll down to date. What is your location set to?

@PReagan 

 

Location is set to English (United Kingdom).

@abc12330,

 

In this case I do not know the answer. Maybe @Sergei Baklan will have an answer for you?

@abc12330 

You may apply custom format like

clipboard_image_0.png

 

@abc12330 

And changing format for entire system you may Win+R, type control international, ok, Additional settings, Date tab, and here, if not available from drop-down list, type desired format and apply

clipboard_image_0.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies