This has to be easy, and extremely common, but I can't find the answer with Google.
I have a column with years (number format) in Excel. I need that column in Excel to be in date format for importing into Tableau. (There may be a way to fix this in Tableua - not relevant here.)
I see way to have a date only show the year in Excel ('yyy').
When I convert my number to a date, I get this:
1999 -> format cells (*3/4/2012) -> 06/21/1905
06/21/1905 -> format cells (yyyy) -> 1905
1999 -> format cells (yyyy) -> 1905
I want 1999 (convert to date format) -> 1999
Thanks for any help.