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
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
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
Giuseppe wrote:
> 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
You could format the cell as such: "Today is"* mm ddd yyyy
Dan
"Giuseppe" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks