Microsoft Excel: Cell Formatting?
This is the issue. I was several dozen spreadsheets filled in with dates. I had to import them into another program in order to compile some information, but I was not able to successfully import unless I imported every field as a character field instead of a date field. After the compilation of the data and making some changes, I exported the data back to new excel spreadsheets.
The issue is all field came back in General format. So I basically changed all the date cells from General format to Date format. I then I applied some conditional formatting to all the cells, but realized the results were not showing up as expected. Basically what I found was this.
Just because you format the actual cells, does not automatically invoke the cell to show in the new format. I had to physically going to the cell itself and go to the end of the date and click enter. However, to have to go inside every date cell to click enter to invoke the format from general to date is a pain in the you know what. Is there anyway to get the formatting to take effect without me having to go into every cell to invoke the formatting?