Formating Date in Excel

[prezlyn]

Hello,

I am trying to format a cell with date format as EX: "28 Mar 1910", but it keeps defaulting to "28-Mar-10". When I try to format the date in "General" it keeps defaulting to "3740"? Can you suggest a fix? I want the entire year published due to the fact that "28-Mar-10" could represent the year 1910, but it could also represent the year 2010. I also do not want the hyphens. Some of the cells in the column will allow "28 Mar 1910" format, however there are some that will not. I am stumped.

Please advise.

Sincerely,
Cristine

 

[Richard U]

select the cells

right click "Format cells"

select custom format

then type "d mmm yyyy" in the textbox (without the quotes)

 

[prezlyn]

Thank you so much! Easy fix. I totally forgot that I could customize the cells that way.

 

[Richard U]

Yw