As I just learned, data is not always converted automatically to the new format, e.g. when it’s a number and you want it to be a date. In that case you have to replace the content with itself after setting the new format.
This can be done with “Find and Replace…”: Search for .* and replace it with & (Ampersand, the whole regex match). Make sure that you have “Regular Expression” checked!