Text and today() in cell

NovaDude

New member
Local time
Today, 05:07
Joined
Aug 1, 2007
Messages
4
How come when I entered:

="today is "&TODAY()

in a cell I get "today is 39307"? I changed the cell format to Date and some other types but it still doesn't work? How do I get it to show "today is 8/13/2007"?
 
Since formatting is by Cell I don't see how you can have a mixed format, why not design to use 2 cells?

Brian
 
Try...
="today is "&TEXT(TODAY(),"mmm dd yyyy")

HTH.
 
Cool DanG, that works! Thanks a lot!!!

Brian, I thought about using 2 cells but I couldn't get it to work. But DanG's formula will do. Thanks.
 
Yeah, when I saw DanG's post I thought " Damn I'm getting rusty" :(

Brian
 
No, it's the law of averages.
I was bound to get one right sooner or later.
 

Users who are viewing this thread

Back
Top Bottom