AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
I suspect t this can't be done..
- Select the cells you want to format.
- Press CTRL+1.
- In the Format Cells box, click the Number tab.
- In the Category list, click Date.
- Under Type, pick a date format. ...
- If you want to use a date format according to how another language displays dates, choose the language in Locale (location
- I want conditionally use dd mmm YYYY or YYYY if my year is 1940
Neither are options in the Type list. Is it possible to add them?