SOLVED

Prevent addition of period when drag auto incrementing short weekday names

%3CLINGO-SUB%20id%3D%22lingo-sub-2055876%22%20slang%3D%22en-US%22%3EPrevent%20addition%20of%20period%20when%20drag%20auto%20incrementing%20short%20weekday%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2055876%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20auto%20incrementing%20weekdays%20by%20theyr%20abbreviation%20excel%20adds%20a%20period%20even%20if%20the%20initial%20field%20did%20not%20have%20one%20(german%20language)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-01-13%2009_33_26-Window.png%22%20style%3D%22width%3A%20136px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246037i850F80536F43974F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-01-13%2009_33_26-Window.png%22%20alt%3D%222021-01-13%2009_33_26-Window.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-01-13%2009_33_55-Window.png%22%20style%3D%22width%3A%20133px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246038iB7AB5AC22F788FD3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-01-13%2009_33_55-Window.png%22%20alt%3D%222021-01-13%2009_33_55-Window.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20to%20have%20is%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-01-13%2009_35_28-Window.png%22%20style%3D%22width%3A%20103px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246039i5AA6E4845C3D36DD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-01-13%2009_35_28-Window.png%22%20alt%3D%222021-01-13%2009_35_28-Window.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20does%20excel%20get%20this%20format%20from%20and%20how%20can%20I%20change%20this%20without%20having%20to%20format%20every%20cell%3F%20I%20have%20not%20found%20a%20setting%20in%20windows%20region%20settings%20for%20this%20particular%20weekday%20format.%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2055876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2055922%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20addition%20of%20period%20when%20drag%20auto%20incrementing%20short%20weekday%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2055922%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927255%22%20target%3D%22_blank%22%3E%40giordnas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20this%20setting%20in%20File-%26gt%3BOptions%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20670px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246042i2B6AD9FEE8D31C98%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

Hi

 

When auto incrementing weekdays by theyr abbreviation excel adds a period even if the initial field did not have one (german language):

 

2021-01-13 09_33_26-Window.png2021-01-13 09_33_55-Window.png

 

What I would like to have is this

 

2021-01-13 09_35_28-Window.png

 

Where does excel get this format from and how can I change this without having to format every cell? I have not found a setting in windows region settings for this particular weekday format.

Thanks in advance

 

1 Reply
best response confirmed by giordnas (Regular Visitor)
Solution

@giordnas 

Please check this setting in File->Options

image.png