I want to this in a cell:
="Today is " & Today()
If I just put:
=TODAY()
in a cell, it shows the date. If I put text in front of it, it shows a long number...not a date.
What am I doing wrong?
I want to this in a cell:
="Today is " & Today()
If I just put:
=TODAY()
in a cell, it shows the date. If I put text in front of it, it shows a long number...not a date.
What am I doing wrong?
I don't think you can have two different formats in the same cell. The numbers that you are seeing are, I think, Boolean Date...which is a text format The only thing that I can suggest is to have one column with "Today Is" and the next column with the date.
Good luck
Try this,
="Today is "&TEXT(TODAY(),"dd/mm/yyyy")
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks