View original (French)

How to reverse a date format dd/mm/yyyy to yyyy/mm/dd

fdht Posted messages 4 Status Membre -  
 :) -
Hello,
I'm looking for how to reverse 22/05/2007 12:35:00, meaning I want to have 2007/05/22 12:35:00

Configuration: Windows 7 / Firefox 16.0

2 réponses

Réponse 1 / 2
synopsis8 Posted messages 1478 Status Membre 243
 
Right-click on the cell, choose the format "custom," and enter YYYY/MM/DD hh:mm:ss.
1
fdht Posted messages 4 Status Membre
 
I right-clicked but I see "Format Cells," and by clicking on it, I can get the format YYYY/MM/DD hh:mm:ss, and worse, it's still the normal format that we see in the formula bar. Thank you for your help.
0
Mytå Posted messages 4246 Registration date   Status Contributeur Last intervention   957
 
Hello forum

In the formula bar, it's normal to see 22/05/2007 12:35:00
this comes from regional settings. However, you need to have the correct format in the cell.

Mytå
0
:)
 
Please, what is that? aaaa-mm-jj?
-1
Réponse 2 / 2
synopsis8 Posted messages 1478 Status Membre 243
 
It's not possible, if you change the format, it must be applied as I told you.
0