Insert date and time into cell with existing text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bam - 31 Aug 2007 00:57 GMT

Question: I maintain an issues list in Excel. One column contains notes. I'd
like to somehow enter today's date (or today's date and time) into a cell
with existing text.

The eventual output would look like this (all in one cell)

08/20/07: some update about the issue. 08/18/07: some earlier update about
the issue

Reply to this Message

Niek Otten - 31 Aug 2007 07:27 GMT

Look here:

http://www.mcgimpsey.com/excel/timestamp.html

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Question: I maintain an issues list in Excel. One column contains notes. I'd
| like to somehow enter today's date (or today's date and time) into a cell
[quoted text clipped - 4 lines]
| 08/20/07: some update about the issue. 08/18/07: some earlier update about
| the issue

Reply to this Message

bam - 31 Aug 2007 13:32 GMT

Perfect, thanks very much

> Look here:
>
[quoted text clipped - 11 lines]
> about
> | the issue

Reply to this Message

Rate this thread: