I'm extracing some data from a database, and the dates I get are in the format yyyy/mm/dd. When I go to "format cells" and change the format to dd/mm/yyyy (or any other format), the values don't change unless I go and double-click the cell to edit it.

Why is this happening? Is there a way to fix it?

JP