This no longer seems to be the case. I've always found it easy to tell it what format a cell is.