Hi, all, Usually, we set a format to a cell, then type in datas, the data will be converted to the format we set.
For example, we format a cell to Currency, then input a number into this cell, the number will be converted to Currency format. But if we set Date format to a cell, then type in a number, the cell format will be converted to number automatically, I think this maybe a feature, because it almost imposible for us to type a number to input a date, if we input a number, we will. And there is another case, if we set Logical value to a cell, the type in a number, the cell format will convert to number too, if we want it to be a logical value, we must set Logical value to this cell again. Does this work as designed? Thank you! Best regards, Zhu Lihua
