Home

Worst Feature of All Time! -Date Auto Correct-

%3CLINGO-SUB%20id%3D%22lingo-sub-189760%22%20slang%3D%22en-US%22%3EWorst%20Feature%20of%20All%20Time!%20-Date%20Auto%20Correct-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHello%20everyone%20I%20apologize%20beforehand%20if%20I%20start%20to%20sound%20a%20little%20angry.%20I%20simply%20want%20to%20express%20my%20point%20of%20view%20and%20see%20if%20anyone%20shares%20the%20same%20thoughts%20or%20not.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20auto%20correct%20date%20function%20is%20the%20most%20irritating%20function%20in%20all%20of%20excel!%20I%20simply%20want%20to%20type%20the%20characters%206-8%20that%20has%20nothing%20to%20do%20with%20the%20date%20whatsoever%20yet%20it%20corrects%20it%20to%20the%20date%20%3CEM%3Eevery%20time%3C%2FEM%3E.%20I%20have%20tried%20to%20enter%20the%20way%20I%20want%20several%20different%20ways%2C%20but%20there%20is%20no%20physical%20way%20to%20have%20exactly%20what%20I%20want%20typed%20in%20the%20cell%20because%20it%20corrects%20it%20no%20matter%20how%20it%20is%20put%20in.%20Furthermore%2C%20I%20sometimes%20use%20excel%20for%20my%20training%20logs%20and%20I%20like%20to%20list%20the%20date%20of%20each%20day%20as%205%2F2%20and%20nothing%20more%2C%20but%20it%20continues%20to%20correct%20it.%20I%20think%20this%20correction%20should%20never%20be%20default%2C%20and%20should%20only%20occur%20if%20I%20choose%20to%20correct%20it%20that%20way.%20I%20don't%20see%20why%20it%20should%20ever%20get%20corrected%20in%20the%20first%20place.%20If%20I%20want%20the%20full%20date%20it%20takes%20less%20than%20half%20a%20second%20to%20type%20the%20extra%202-4%20characters.%20The%20feature%20does%20NOT%20save%20time%2C%20in%20fact%2C%20it%20does%20the%20opposite.%20The%20correction%20wastes%20everyone's%20time%20by%20forcing%20us%20to%20go%20back%20and%20fix%20it%20every%20single%20time%20it%20happens%20and%20use%20undesired%20characters%20even%20when%20unrelated%20to%20date.%26nbsp%3BUsers%20should%20have%20the%20ability%20to%20type%20the%20date%20exactly%20as%20they%20want%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIf%20anyone%20can%20tell%20me%20how%20to%20turn%20off%20the%20date%20correction%20completely%20it%20would%20be%20very%20appreciated.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20anyone%20else%20finds%20this%20feature%20annoying.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-189760%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189879%22%20slang%3D%22en-US%22%3ERe%3A%20Worst%20Feature%20of%20All%20Time!%20-Date%20Auto%20Correct-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189879%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Matthew%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20that%20there%20is%20no%20option%20to%20turn%20off%20this%20feature!%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20there%20is%20an%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10108722-allow-us-to-turn-off-automatic-conversion-to-date%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eidea%3C%2FA%3E%20in%20the%20Excel's%20suggestion%20box%20asking%20for%20this%2C%26nbsp%3Byou%20can%20vote%20for%20it%20as%20I%20did.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20now%2C%20you%20can%20preset%20the%20format%20of%20empty%20cells%20to%20%3CSTRONG%3EText%20%3C%2FSTRONG%3Eso%20that%20anything%20you%20typed%20will%20stay%20as%20it%20is.%3C%2FP%3E%3CP%3ETo%20do%20that%2C%20select%20the%20cells%2C%20press%20%3CSTRONG%3ECtrl%2B1%3C%2FSTRONG%3E%2C%20choose%20%3CSTRONG%3EText%3C%2FSTRONG%3E%20from%20the%20%3CSTRONG%3ECategory%3C%2FSTRONG%3E%20list%20and%20then%20hit%20%3CSTRONG%3EOK%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874942%22%20slang%3D%22en-US%22%3ERe%3A%20Worst%20Feature%20of%20All%20Time!%20-Date%20Auto%20Correct-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874942%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3EFunny%20thing%20about%20text%20formatting...It%20doesn't%20work%20correctly!%20If%20you%20are%20importing%20a%20text%20dataset%20with%20more%20than%20998%20columns.%20All%20cell%20formatting%20will%20be%20ignored%20for%20columns%20999%2B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20preformat%20the%20entire%20sheet%20to%20text%2C%20doesn't%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20select%20all%20columns%20in%20the%20import%20wizard%20and%20set%20them%20to%20text%2C%20the%20preview%20mode%20doesn't%20seem%20to%20see%20anything%20beyond%20998%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20try%20to%20reformat%20the%20cells%20to%20%22text%22%20afterwards%2C%20it%20converts%20the%20fields%20to%20a%20number%20i.e.%201%2F1%20-%26gt%3B%2043466.%20If%20you%20try%20to%20(Ctrl%20%2B%20H)%20replace%20all%2043466%20with%201%2F1%20or%20'1%2F1%2C%20specifying%20%22text%22%20cell%20format%20in%20the%20replace%20all%20options%2C%20it%20forcibly%20converts%20the%201%2F1%20back%20to%201-Jan%20with%20a%20%22custom%22%20cell%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDate%20correction%20is%20a%20special%20level%20of%20hell%20from%20which%20there%20is%20no%20escape%20beyond%20manually%20typing%20%22'1%2F1%22%20with%20an%20apostrophe%2019%2C787%20times.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Matthew Leonard
Occasional Visitor

Hello everyone I apologize beforehand if I start to sound a little angry. I simply want to express my point of view and see if anyone shares the same thoughts or not.

The auto correct date function is the most irritating function in all of excel! I simply want to type the characters 6-8 that has nothing to do with the date whatsoever yet it corrects it to the date every time. I have tried to enter the way I want several different ways, but there is no physical way to have exactly what I want typed in the cell because it corrects it no matter how it is put in. Furthermore, I sometimes use excel for my training logs and I like to list the date of each day as 5/2 and nothing more, but it continues to correct it. I think this correction should never be default, and should only occur if I choose to correct it that way. I don't see why it should ever get corrected in the first place. If I want the full date it takes less than half a second to type the extra 2-4 characters. The feature does NOT save time, in fact, it does the opposite. The correction wastes everyone's time by forcing us to go back and fix it every single time it happens and use undesired characters even when unrelated to date. Users should have the ability to type the date exactly as they want it. 

If anyone can tell me how to turn off the date correction completely it would be very appreciated.

Let me know if anyone else finds this feature annoying.

2 Replies

Hi Matthew,

 

It seems that there is no option to turn off this feature!

By the way, there is an idea in the Excel's suggestion box asking for this, you can vote for it as I did.

 

For now, you can preset the format of empty cells to Text so that anything you typed will stay as it is.

To do that, select the cells, press Ctrl+1, choose Text from the Category list and then hit OK.

 

Regards

@Haytham AmairahFunny thing about text formatting...It doesn't work correctly! If you are importing a text dataset with more than 998 columns. All cell formatting will be ignored for columns 999+.

 

You can preformat the entire sheet to text, doesn't help.

 

You can select all columns in the import wizard and set them to text, the preview mode doesn't seem to see anything beyond 998 columns.

 

If you try to reformat the cells to "text" afterwards, it converts the fields to a number i.e. 1/1 -> 43466. If you try to (Ctrl + H) replace all 43466 with 1/1 or '1/1, specifying "text" cell format in the replace all options, it forcibly converts the 1/1 back to 1-Jan with a "custom" cell format.

 

Date correction is a special level of hell from which there is no escape beyond manually typing "'1/1" with an apostrophe 19,787 times.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies