Change date format of cell in excel from dd mm yyyy to yyy mm dd excel version 2013

0 votes

I have been searching it for an hour but unfortunately nothing found that actually work. I have an excel sheet with a column having date in it. Current date format is dd.mm.yyyy but I want to change date format to yyyy/mm/dd for entire cell.

Feb 9, 2022 in Others by Edureka
• 13,640 points
659 views

1 answer to this question.

0 votes

Hello :)  

Excel’s Format Cells function can quickly convert dd-mm-yyyy to yyyy-mm-dd format.

 Select the dates you want to convert, and right click to display context menu, and select Format Cells from it and then
 in the Format Cells dialog, under Number tab, click Custom from the list, and type yyyy-mm-dd into the Type textbox in the right section.Click OK. Now all dates are converted to yyyy-mm-dd format

answered Feb 9, 2022 by gaurav
• 22,940 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 51,240 points
47 views
0 votes
1 answer
0 votes
1 answer

Change the size of one cell in excel 2016

I'm sorry, but it's not feasible. A ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 51,240 points
75 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

answered Dec 25, 2022 in Others by narikkadan
• 51,240 points
49 views
0 votes
2 answers

Define a SQL query? What is the difference between SELECT and UPDATE Query? How do you use SQL in SAS?

HI.. SQL is Structured Query Language, which is ...READ MORE

answered Aug 8, 2020 in PHP by anonymous
5,906 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
522 views
0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 22,940 points
544 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8, 2022 in Others by gaurav
• 22,940 points
68 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP