dragonmouse
Board Regular
- Joined
- May 14, 2008
- Messages
- 129
- Office Version
- 2016
- Platform
- Windows
I transferred some data from Crystal Reports to EXCEL.
The date transferred appears as "Dec-2021" which is PERFECT and what I want...HOWEVER....this is just formatting. The REAL (if you click on it and look at the input line) date is "12/15/2021 10:37:45 AM". The formula I hve wants to see specifically "Dec-2021" not the other nonsense. How can I convert 12/15/2021 10:37:45 AM to be truly "Dec-2021"
The date transferred appears as "Dec-2021" which is PERFECT and what I want...HOWEVER....this is just formatting. The REAL (if you click on it and look at the input line) date is "12/15/2021 10:37:45 AM". The formula I hve wants to see specifically "Dec-2021" not the other nonsense. How can I convert 12/15/2021 10:37:45 AM to be truly "Dec-2021"