Dates format suddenly changed to general formats

%3CLINGO-SUB%20id%3D%22lingo-sub-2009849%22%20slang%3D%22en-US%22%3EDates%20format%20suddenly%20changed%20to%20general%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009849%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20was%20working%20on%20my%20excel%20file%20(with%20multiple%20sheets)%2C%20when%20suddenly%2C%20all%20the%20dates%20format%20changed%20to%20general%20formats.%26nbsp%3B%20I%20started%20working%20on%20this%20excel%20file%205%20years%20ago%20until%20present%20and%20now%2C%20all%20the%20dates%20formats%20became%20general%20numbers!!!%26nbsp%3B%20I%20don't%20know%20what%20I%20clicked!%26nbsp%3B%20Can%20anybody%20help%20how%20to%20restore%20them%20back%20to%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2009849%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2009991%22%20slang%3D%22en-US%22%3ERe%3A%20Dates%20format%20suddenly%20changed%20to%20general%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909570%22%20target%3D%22_blank%22%3E%40Edmon44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20the%20cells%20that%20you%20want%20to%20change%20the%20format%20to%20date%2C%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22date%20format.png%22%20style%3D%22width%3A%20902px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242238iF33C8DD16DFD7CBD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22date%20format.png%22%20alt%3D%22date%20format.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20Ctrl%20%2B%201%20%2C%20then%20from%20the%20Format%20window%2C%20from%20the%20category%20choose%20date%2C%20then%20click%20on%20the%20date%20format%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello. I was working on my excel file (with multiple sheets), when suddenly, all the dates format changed to general formats.  I started working on this excel file 5 years ago until present and now, all the dates formats became general numbers!!!  I don't know what I clicked!  Can anybody help how to restore them back to 

2 Replies

@Edmon44 

 

Select the cells that you want to change the format to date,

date format.png

 

Or Ctrl + 1 , then from the Format window, from the category choose date, then click on the date format you want.

 

 

 

@Jihad Al-JaradyHi, hoping you read this; taking opportunity of this question. What else I can do if even selecting the way you described it keeps changing to general format automatically once I click on save?