So an odd question, maybe really easy. I have a large spreadsheet, with a few columns that will be filled in by various users as time goes on. Currently those are date columns, however, this question isn't restricted to dates.
Once I enter some dates, I noticed that they are formatted in a format I'd rather not use (ie my default Windows format) :( Anyway, I'd like to use a standard, default format (ie dd-mmm-yyyy) to avoid any confusion between dates like "07/08/09" O.o
I can set that format on the entire column(s), however, the format doesn't seem to "stick" to blank cells. Once I go in and enter a new value into a cell that was empty, it doesn't use the format I specified.
Is there a way to force Excel to set the default format for the ENTIRE column, blank cells or otherwise ?