excel date format issue

[nikhilboorla]

I have date format like 01-01-1900  00:00:00 and i want the format to be like 1900-01-00 00:00 but it's not changing as it is text format and i have tried many solutions like clicking text to columns,changing format in format cells ,apply format painter,specifying =datevalue() function in empty cell but none of them worked.Can anybody help me in overcoming this issue?

[sanjaysahu]

https://www.ablebits.com/office-addins-blog/2015/03/11/change-date-format-excel/

 

 

Creating a custom date format in Excel

If none of the predefined Excel date formats is suitable for you, you are free to create your own.

1. In an Excel sheet, select the cells you want to format.
2. Press Ctrl+1 to open the Format Cells dialog.
3. On the Number tab, select Custom from the Category list and type the date format you want in the Type box.
   

    

   Tip. The easiest way to set a custom date format in Excel is to start from an existing format close to what you want. To do this, click Date in the Category list first, and select one of existing formats under Type. After that click Custom and make changes to the format displayed in the Type box.

When setting up a custom date format in Excel, you can use the following codes.

Code	Description	Example (January 1, 2005)
m	Month number without a leading zero	1
mm	Month number with a leading zero	01
mmm	Month name, short form	Jan
mmmm	Month name, full form	January
mmmmm	Month as the first letter	J (stands for January, June and July)
d	Day number without a leading zero	1
dd	Day number with a leading zero	01
ddd	Day of the week, short form	Mon
dddd	Day of the week, full form	Monday
yy	Year (last 2 digits)	05
yyyy	Year (4 digits)	2005

When setting up a custom time format in Excel, you can use the following codes.

Code	Description	Displays as
h	Hours without a leading zero	0-23
hh	Hours with a leading zero	00-23
m	Minutes without a leading zero	0-59
mm	Minutes with a leading zero	00-59
s	Seconds without a leading zero	0-59
ss	Seconds with a leading zero	00-59
AM/PM	Periods of the day (if omitted, 24-hour time format is used)	AM or PM

Note. If you're setting up a custom format that includes date and time values and you use "m" immediately after "hh" or "h" or immediately before "ss" or "s", Microsoft Excel will displayminutes instead of the month.

When creating a custom date format in Excel, you can use a comma (,) dash (-), slash (/), colon (:) and other characters.

For example, the same date and time, say January 13, 2015 13:03, can be displayed in a various ways:

Format	Displays as
dd-mmm-yy	13-Jan-15
mm/dd/yyyy	01/13/2015
m/dd/yy	1/13/15
dddd, m/d/yy h:mm AM/PM	Tuesday, 1/13/15 1:03 PM
ddd, mmmm dd, yyyy hh:mm:ss	Tue, January 13, 2015 13:03:00

[Srin]

GP

[SlMHAM]

[Quickgun_murugan]

GGP