Dates Formatting in Excel

Closed
Moe - May 26, 2010 at 10:17 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 26, 2010 at 10:59 AM
Hi All,

Thanks in advance for your help. I am autoformatting my dates in Excel 2007 to read as mmm-dd-yyy (i.e. Jan-01-2010) which is working perfectly. However, I also want to have the option to put in partial dates such as (only) "2010". However, if I simply input 2010 into the cell, it calculates based on Excel number dates (it converts it to Jul-02-1905). Is there any way for it to autoformat to when the date is fully filled in but also allow you to input partial dates?



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 10:59 AM
either you have to use a custom formula to enter date or you have to enter year as text
so instead of 2010

enter '2010

' will indicate that treat the value as text
0