Hello together,

does anybody know how I can force Excel to update the format of a cell after I assigned a new value?

I want to insert a date into a cell (e.g. 2012/10/10) and the format of the cell is mm/yyyy. Unfortunately Excel only shows the new format after I put the cell into enter mode with F2 and pressed enter.

Thanks!