Pour créer cet article, 20 personnes, certaines anonymes, ont participé à son édition et à son amélioration au fil du temps. I have a column in Excel Sheet which contains all the dates in custom dd-mm-yyyy format. Cet article a été consulté 2 467 fois. Avez-vous reçu un document avec les dates dans le mauvais format ? I want it to be text. This page describes the following three different methods, that can be used to convert a date to text in Excel.The quickest way to convert an Excel date to text is to insert an apostrophe in front of the date (see The apostrophe will not be displayed in the cell, but it will tell Excel to treat the contents of the cell as text.If you want to convert an entire column of Excel dates to text, you might prefer to use the Excel Text to Columns command.However, note that the Text to Columns command only works on one column of data at a time.To use the Excel Text to Columns command to convert dates to text:This will cause the Convert Text to Columns wizard to open up. Excel refuse obstinément d’appliquer un autre format de date à du texte comme « anniversaire de maman » ou « 12.02.2009 ». If you require permanently changing the date format that applies to current as well as future work in Excel, then you should change this in control panel. Format Date or Time using TEXT function. Joined Apr 4, 2008 Messages 20. If I am changing the cell format to Text, I am losing the format.

Sometimes, we may need to display date and time together. Last edited: Oct 7, 2009. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Change-Date-Formats-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-460px-Change-Date-Formats-in-Microsoft-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Change-Date-Formats-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-728px-Change-Date-Formats-in-Microsoft-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"