Forum Discussion
Brittdick
Jan 20, 2021Copper Contributor
Normal, Neutral, Good, and Bad
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
- Riny_van_EekelenPlatinum Contributor
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.
- BrittdickCopper Contributor
Riny_van_Eekelen Thank you!!
I had no idea.