SOLVED

excel displays number for date

%3CLINGO-SUB%20id%3D%22lingo-sub-2647262%22%20slang%3D%22en-US%22%3Eexcel%20displays%20number%20for%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647262%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20excel%20spreadsheet%20Column%20D%2C%20I%20have%20dates%20that%20display%20as%20numbers%20in%20the%20cell%20but%20in%20the%20formula%20box%20show%20as%20a%20date.%20These%20have%20not%20been%20imported%2C%20I%20manually%20entered%20all%20of%20them.%20Something%20I%20did%20and%20don't%20aske%20me%20what%20ahs%20changed%20the%20formatting.%20Some%20of%20the%20cells%20in%20Column%20D%20show%20as%20a%20date%20but%20I%20have%20no%20idea%20why.%20I%20have%20tried%20formatting%20the%20cells%20to%20date%20but%20nothing%20is%20working.%26nbsp%3B%20What%20am%20I%20missing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2647262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647354%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20displays%20number%20for%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128148%22%20target%3D%22_blank%22%3E%40Don9of11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fdisplay-or-hide-formulas-f7f5ab4e-bf24-4efc-8fc9-0c1b77a5356f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fdisplay-or-hide-formulas-f7f5ab4e-bf24-4efc-8fc9-0c1b77a5356f%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2648156%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20displays%20number%20for%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2648156%22%20slang%3D%22en-US%22%3EOkay%2C%20thank%20you%20very%20much%20that%20took%20care%20of%20the%20issue.%3C%2FLINGO-BODY%3E
New Contributor

In my excel spreadsheet Column D, I have dates that display as numbers in the cell but in the formula box show as a date. These have not been imported, I manually entered all of them. Something I did and don't aske me what ahs changed the formatting. Some of the cells in Column D show as a date but I have no idea why. I have tried formatting the cells to date but nothing is working.  What am I missing?

2 Replies
best response confirmed by Don9of11 (New Contributor)
Okay, thank you very much that took care of the issue.