Use of Now() in Excel

[Guest]

Hi all,
I need help hot to use Now() in a cell.
My problem is:
I 'll write in a cell [Today is Now()] --> I will have all in one cell.
Thank you in advance
Best
Giuseppe

 

[texastek76]

Try this:

="Today is "&TEXT(NOW(),"mm/dd/yy hh:mm:ss")

To get this result:

Today is 06/27/05 07:45:59

OR

="Today is "&TEXT(NOW(),"mm/dd/yy")

To get this result:

Today is 06/27/05

-Scott

 

[Dan Chupinsky]

You could format the cell as such: "Today is"* mm ddd yyyy

Dan