Normal, Neutral, Good, and Bad

%3CLINGO-SUB%20id%3D%22lingo-sub-2079079%22%20slang%3D%22en-US%22%3ENormal%2C%20Neutral%2C%20Good%2C%20and%20Bad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079079%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20used%20the%20%22neutral%22%20cell%20style%20to%20highlight%20some%20rows.%20I%20now%20would%20like%20to%20delete%20that%20and%20go%20back%20the%20%22normal%22%2C%20but%20when%20I%20click%20on%20normal%20it%20changes%20info%20in%20some%20of%20my%20cells!%20Two%20of%20my%20columns%20are%20dates%2C%20when%20I%20click%20%22normal%22%2C%20it%20changes%20those%20dates%20into%20some%20random%20numbers!%20How%20can%20I%20make%20this%20not%20happen%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2079079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I had used the "neutral" cell style to highlight some rows. I now would like to delete that and go back the "normal", but when I click on normal it changes info in some of my cells! Two of my columns are dates, when I click "normal", it changes those dates into some random numbers! How can I make this not happen?

2 Replies

@Brittdick Just select the columns with date and format them as Dates. What you see are not random numbers. Dates are, in fact, numbers counting days from January 1, 1900. Todays date, for instance, is January 20, 2021. For Excel that's number 44216.

@Riny_van_Eekelen Thank you!!

I had no idea.