This seems to be a problem quite smilar to dynamic or static typing. The users expect that Excel will figure out what to do with the input correctly. But you

This seems to be a problem quite smilar to dynamic or static typing. The users expect that Excel will figure out what to do with the input correctly. But you can manually tell Excel what to do with data in a column.