Forum Discussion
Two dates in one cell
Hi all, I have trouble finding out how to do this. I want to fit in two dates in one cell without messing up the format the format I have in mind is d-mmm-yy however everytime I input two ...
Dyla_1806 You mean like this?
When you enter 01-jan-21, Excel recognises it as a data. It gets "translated" to 01/01/2021 but its displayed as you typed it. If you than add " - 02-jan-21" to that, it become a text like in the picture above. So, just type the whole text string in one go "01-jan-21 - 02-jan-21". Then it will show as desired. But, be aware that you are no longer working with real dates.
Yes except when I input it as what you told me to it came out as
01/01/2021-02/01/2021
01/01/2021-02/01/2021
Dyla_1806 Can't replicate that on my machine. When I enter the string as in my previous post, I get this: