Convert date format 01/05/2018 and 01/may/2018 to (dd/mm/yyyy) format and save same format into excel using c#

excel convert text to date dd/mm/yyyy
how to change date format in excel
how to change date format in excel to dd/mm/yyyy
how to change date format in excel to dd/mm/yyyy using formula
convert text to date in excel
date format not changing in excel
how to change date format in excel to dd/mm/yyyy hh:mm:ss
excel not recognizing date format

I Have two type of date formats like 01/05/2018 and 01/may/2018. I want to convert both formats into (dd/MM/yyyy), how do I convert it and save into excel file. I have a problem in saving data into excel, the save not proper format, its change like a month comes first and sometimes date come first the code is:- mystring=mystring.tostring.parse("dd/MM/yyyy")


I believe you have to do:

targetRange.NumberFormat = "dd/MM/yyyy";

Where targetRange is either the Cell or Column that you want to have the required date format

The format must also be something that Excel understands and this is not always the same as what C# uses

How to change Excel date format and create custom formatting, Knowing the Excel date formats a little in depth can help you save a ton of your time. If you want to quickly set date format in Excel to dd-mmm-yy, press Ctrl+​Shift+#. mm, Month number with a leading zero, 01 You may want to change the cell alignment to right justified, and naturally, you can use any  When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01 00:00:00.000 But if you need to display the datetime in a human readable format you will need to convert it using CONVERT to cast it as a VARCHAR. For example, to convert the column ‘Date_Of_Birth’ to dd-mm-yyyy format.


You can provide several formats when using DateTime.ParseExact. So you can parse initial string into DateTime and then format the DateTime into required format.

  string[] tests = new string[] {
    "01/05/2018",
    "01/may/2018",
  };

  string[] formats = new string[] {
    "d/M/yyyy",    // try this format first
    "d/MMMM/yyyy", // on fail try this one etc.
  };

  string[] results = tests
    .Select(item => DateTime.ParseExact(item, 
                                        formats,
                                        CultureInfo.InvariantCulture, 
                                        DateTimeStyles.AssumeLocal))
    .Select(date => date.ToString("dd'/'MM'/'yyyy")) // '/' - to preserve / 
    .ToArray();

  Console.Write(Environment.NewLine, results);

Outcome:

01/05/2018
01/05/2018     

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in , How do I change the date format in Excel to DD MMM YYYY? I am getting the DateTime from one application and passing this object to other application and That application is storing that date into MySql's DateTime field which is in the format "yyyy-MM-dd". This is why I have posted this question.


I had similar problem and I tried the code below

DateTime date = DateTime.Now;
string formattedDate = date.ToString("dd'/'MM'/'yyyy");

Convert date to text in Excel, How do I change the date format on a chart? How to change date format in Excel and create custom formatting by Svetlana Cheusheva | updated on September 18, 2019 402 Comments The first part of our tutorial focuses of formatting dates in Excel and explains how to set the default date and time formats, how to change date format in Excel, how to create custom date formatting, and convert


DateTime.ParseExact Method (System), How do I change the European date format in Excel? To format a date, you just write the parameter d, m or y different number of times. For example, dd/mm/yyyy will display the 1st of January 2016 as 01 Jan 2016. By entering the codes 1,2,3 or 4 times, the display will be different.


How to Change Date and Time Formats in Your Text Automatically, How do I change the date format of a dot in Excel? This is the correct answer, but it has the wrong format. So you need to change the date format. 3. Select the cell B1 and right-click, choose Format Cells from the context menu. In the Format Cells dialog box, click Number > Date, and choose the local date as you need.


How to convert dD.MM.YYYY to date format (mM/DD/YYYY) in Excel?, See how to use the Excel TEXT function for converting a date to text string in the specified format and how to achieve the same results in a "mm/dd/yyyy" - the date format used in the USA, displays as 03/08/2015. The results of your TEXT formulas may look similar to this: May 18, 2018 at 5:19 am. Make sure you type dates according to computer date formats, otherwise your dates will be wrong. For example, if you type 11-10, this will be converted by excel as November 10 if regional date format is mm/dd/yyyy, and it will be converted to October 11, if dd/mm/yyyy is the system date format. Catalin