Assign a value to the range; if necessary, the value will be converted to another data type, and the cell's number format will be reset....Assign a value to the range; if necessary, the value will be converted to another data type, and the cell's number format will be reset.