Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 114
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello
I have a cell where I have entered the following:
="STATUS "&TODAY()
I would like that cell to read : STATUS 2024-02-23
What is does read : STATUS 45345
I understand what that number means, but I would like to format the cell so that it does not show like that. Does anyone know a way around this?
I have a cell where I have entered the following:
="STATUS "&TODAY()
I would like that cell to read : STATUS 2024-02-23
What is does read : STATUS 45345
I understand what that number means, but I would like to format the cell so that it does not show like that. Does anyone know a way around this?