N NovaDude New member Local time Today, 05:07 Joined Aug 1, 2007 Messages 4 Aug 13, 2007 #1 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"?
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"?
Brianwarnock Retired Local time Today, 10:07 Joined Jun 2, 2003 Messages 12,701 Aug 13, 2007 #2 Since formatting is by Cell I don't see how you can have a mixed format, why not design to use 2 cells? Brian
Since formatting is by Cell I don't see how you can have a mixed format, why not design to use 2 cells? Brian
DanG Registered User. Local time Today, 02:07 Joined Nov 4, 2004 Messages 477 Aug 13, 2007 #3 Try... ="today is "&TEXT(TODAY(),"mmm dd yyyy") HTH.
N NovaDude New member Local time Today, 05:07 Joined Aug 1, 2007 Messages 4 Aug 13, 2007 #4 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.
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.
Brianwarnock Retired Local time Today, 10:07 Joined Jun 2, 2003 Messages 12,701 Aug 14, 2007 #5 Yeah, when I saw DanG's post I thought " Damn I'm getting rusty" Brian
DanG Registered User. Local time Today, 02:07 Joined Nov 4, 2004 Messages 477 Aug 14, 2007 #6 No, it's the law of averages. I was bound to get one right sooner or later.