Neomatrix
New Member
- Joined
- Feb 3, 2021
- Messages
- 11
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- Mobile
Cells are formatted as text for each month of 2020 like this 01/2020 02/2020 03/2020 ..... until 12/2020. After selecting all 12 cells and replacing 2020 with 2021, using Ctrl+H to replace all at once, excel automatically turns into date format (01.jan)