{"id":335,"date":"2014-04-25T19:53:47","date_gmt":"2014-04-25T17:53:47","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=335"},"modified":"2022-08-09T14:55:16","modified_gmt":"2022-08-09T12:55:16","slug":"excel-aligner-les-jours-de-la-semaine-dans-un-format-de-date-2","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/04\/excel-aligner-les-jours-de-la-semaine-dans-un-format-de-date-2\/","title":{"rendered":"Excel &#8211; Aligner les jours de la semaine dans un format de date"},"content":{"rendered":"<p><strong>Contexte<\/strong><\/p>\n<p>Vous avez cr\u00e9\u00e9 un tableau comportant une colonne dans laquelle vous avez saisi des dates avec un format personnalis\u00e9 de type jjjj jj mm aa afin d&rsquo;obtenir automatiquement les jours de la semaine en texte. Probl\u00e8me : vous aimeriez que les jours de la semaine soient align\u00e9s \u00e0 gauche&nbsp; de la cellule (puisqu&rsquo;il s&rsquo;agit de texte) alors que les dates doivent \u00eatre align\u00e9es \u00e0 droite.<\/p>\n<p><strong>Solution<\/strong><\/p>\n<ul>\n<li>S\u00e9lectionnez la plage de cellules dans laquelle vous avez saisi les dates<\/li>\n<li>Allez dans Format &gt; Cellule &gt; Personnalis\u00e9e et cr\u00e9ez le format personnalis\u00e9 suivant :<br \/>\njjjj* jj mm aa. Remarquez qu&rsquo;il y a un espace apr\u00e8s le *<\/li>\n<li>Validez<\/li>\n<\/ul>\n<p>Bon \u00e0 savoir : le symbole * suivi d&rsquo;un espace r\u00e9p\u00e8te l&rsquo;espace autant de fois qu&rsquo;il est n\u00e9cessaire en fonction de la longueur du mot (lundi, vendredi)&#8230; R\u00e9sultat, les jours de la semaine sont \u00ab\u00a0pouss\u00e9s\u00a0\u00bb \u00e0 gauche de la cellule alors que les dates restent align\u00e9es \u00e0 droite.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez cr\u00e9\u00e9 un tableau comportant une colonne dans laquelle vous avez saisi des dates avec un format personnalis\u00e9 de type jjjj jj mm aa afin d&rsquo;obtenir&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3353,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[53,49],"class_list":{"0":"post-335","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-date","9":"tag-format"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3353"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}