Excel stopped formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2396851%22%20slang%3D%22en-US%22%3EExcel%20stopped%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2396851%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3EEdition%20Windows%2010%20Pro%3CBR%20%2F%3EVersion%2020H2%3CBR%20%2F%3EInstalled%20on%20%E2%80%8E9%2F%E2%80%8E10%2F%E2%80%8E2020%3CBR%20%2F%3EOS%20build%2019042.985%3CBR%20%2F%3EExperience%20Windows%20Feature%20Experience%20Pack%20120.2212.2020.0%3C%2FP%3E%3CP%3EMicrosoft%20Office%20Professional%20Plus%202019%3CBR%20%2F%3EMicrosoft%20Excel%202019%20MSO%20(16.013929.20360)%2064%20bits%3CBR%20%2F%3EID%3A%2000414-50000-00000-AA730%3C%2FP%3E%3CP%3EMy%20Excel%20just%20stopped%20formatting%20cells.%20Even%20if%20I%20select%20the%20column%20and%20use%20the%20format%20cells%20command%20again%20it%20does%20not%20work.%20I%20tried%20to%20select%20one%20cell%20and%20when%20I%20chose%20%22format%20cells%22%20came%20a%20dialog%20box%20where%20I%20could%20format%20the%20font.%20I%20am%20an%20university%20professor%20and%20use%20this%20command%20a%20lot%20to%20change%20dates%20into%20numbers%20to%20grade%20students%20by%20their%20task%20delivery%20date.%20Can%20someone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2396851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2396973%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stopped%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2396973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1066166%22%20target%3D%22_blank%22%3E%40LuisAraujo1948%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBefore%20you%20go%20to%20the%20link%20with%20the%20individual%20pages%2C%20allow%20me%20to%20recommend%20that%20you%20check%20if%20the%20cell%20%2F%20area%20%2F%20worksheet%20is%20%2F%20are%20locked.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fundo-automatic-formatting-in-excel-54eba206-110c-445a-89f1-c4eb67a36bd4%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%20size%3D%224%22%3EUndo%20automatic%20formatting%20in%20Excel%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3ESometimes%20when%20you%E2%80%99re%20entering%20information%20into%20a%20worksheet%2C%20Excel%20automatically%20formats%20it%20in%20a%20way%20you%20didn%E2%80%99t%20intend.%20For%20example%2C%20if%20you%20type%20a%20web%20address%2C%20Excel%20will%20turn%20it%20into%20a%20hyperlink.%20This%20can%20be%20really%20helpful%2C%20but%20there%20might%20be%20times%20when%20that%E2%80%99s%20not%20what%20you%20want.%20In%20that%20case%2C%20you%20can%20turn%20off%20automatic%20formatting%20for%20one%20cell%20or%20your%20whole%20workbook.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fedit-cell-contents-9c8489f6-08c4-4932-a6bc-4de0a8cf86d6%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%20size%3D%224%22%3EEdit%20cell%20contents%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3EYou%20can%20edit%20the%20contents%20of%20a%20cell%20directly%20in%20the%20cell.%20You%20can%20also%20edit%20the%20contents%20of%20a%20cell%20by%20typing%20in%20the%20formula%20bar.%3C%2FP%3E%3CP%3EWhen%20you%20edit%20the%20contents%20of%20a%20cell%2C%20Excel%20is%20operating%20in%20Edit%20mode.%20Some%20Excel%20features%20work%20differently%20or%20are%20unavailable%20in%20Edit%20mode.%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3EWhen%20Excel%20is%20in%20Edit%20mode%2C%20the%20word%20%3CSTRONG%3EEdit%3C%2FSTRONG%3E%20appears%20in%20the%20lower-left%20corner%20of%20the%20Excel%20program%20window%2C%20as%20shown%20in%20the%20following%20illustration.%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHope%20this%20information%20was%20helpful%20to%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20know%20I%20know%20nothing%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, 

Edition Windows 10 Pro
Version 20H2
Installed on ‎9/‎10/‎2020
OS build 19042.985
Experience Windows Feature Experience Pack 120.2212.2020.0

Microsoft Office Professional Plus 2019
Microsoft Excel 2019 MSO (16.013929.20360) 64 bits
ID: 00414-50000-00000-AA730

My Excel just stopped formatting cells. Even if I select the column and use the format cells command again it does not work. I tried to select one cell and when I chose "format cells" came a dialog box where I could format the font. I am an university professor and use this command a lot to change dates into numbers to grade students by their task delivery date. Can someone help?

1 Reply

@LuisAraujo1948 

Before you go to the link with the individual pages, allow me to recommend that you check if the cell / area / worksheet is / are locked.

Undo automatic formatting in Excel

Sometimes when you’re entering information into a worksheet, Excel automatically formats it in a way you didn’t intend. For example, if you type a web address, Excel will turn it into a hyperlink. This can be really helpful, but there might be times when that’s not what you want. In that case, you can turn off automatic formatting for one cell or your whole workbook.

 

Edit cell contents

You can edit the contents of a cell directly in the cell. You can also edit the contents of a cell by typing in the formula bar.

When you edit the contents of a cell, Excel is operating in Edit mode. Some Excel features work differently or are unavailable in Edit mode.

When Excel is in Edit mode, the word Edit appears in the lower-left corner of the Excel program window, as shown in the following illustration.

 

Hope this information was helpful to you.

 

Nikolino

I know I know nothing (Socrates)