|
View Full Version : Text and today() in cell NovaDude 08-13-2007, 09:25 AM 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 08-13-2007, 09:35 AM 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 08-13-2007, 10:02 AM Try... ="today is "&TEXT(TODAY(),"mmm dd yyyy") HTH. NovaDude 08-13-2007, 01:21 PM 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 08-14-2007, 07:04 AM Yeah, when I saw DanG's post I thought " Damn I'm getting rusty" :( Brian DanG 08-14-2007, 07:58 AM No, it's the law of averages. I was bound to get one right sooner or later. |