Excel seems to have a built-in default for dates. When I type 8-4 (wanting
to represent an 8-hour work schedule from 8am to 4pm) into a blank cell and
then moveto the next cell, the 8-4 in the first cell changes to Aug 4 in
front of my eyes. In addition, even when I text format a cell not to change
8-4 to Aug 4, when I copy and past a cell containing 8-4 to a new workbook,
it changes my texted 8-4 in the old workbook to Aug 4 in the new workbook.
I cannot find how to turn this automatic default feature off. I do not want
to have to continually format individual cells for text.