Hello everyone.

I have a spreadsheet that is used to manage time sheets and invoices.
The weekly time sheets are on separate tabs and the invoice is at the
beginning. The invoice tab uses no special cell content type but Excel
seems to thing all of the cells on that tab are formatted to "Time" and
anything I try to enter into these cells causes an error that "The
number of hours in a day cannot exceed 24". The cell is formatted as
text, plain text. Why would this restriction be there?

Sometimes I can generate the data in another spreadsheet and copy
things into the invoice's cells. For example: I copy "234" from a
blank sheet into the invoice, the cell value changes. If I try to
manually type that same value into that same cell, I get the error. If
I copy the contents from the blank sheet and then edit the cell, I get
the error.

Does anybody have any ideas as to how I can completely reset the
contents of a cell such that it will allow normal text entry again?

Thanks!
Mike