Dates Formatting in Excel

Closed
Moe - 26 May 2010 à 10:17
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 26 May 2010 à 10:59
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?



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
26 May 2010 à 10:59
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