Quote:
Originally Posted by croberts
Well I see a problem. On sheet Jobcost, cells A8 and A9, I cannot use the F2 edit to remove the single quote before the job number, when I remove the single quote, and hit ENTER, the single quote reappears. And when I type over the job (already formatted as text), the single quote gets put back in there by Excel.
|
It's really weird behavior! I was able to correct those cells by:
a) Copying the value in cell over with one behaving normally from upper rows;
b) Copying an upper normally behaving cell, and then PasteSpecial Formats for those 2 cells.
(And I checked Data Validation - there was none defined for those cells)
Looks like a bug!