Thread: How do I change the comment default format to include date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I change the comment default format to include date?
You cannot change the default.

You can run a macro to insert a Comment with date and time.

See Debra Dalgleish's site for code.

http://www.contextures.on.ca/xlcomments03.html#DateTime


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 15:57:01 -0700, frj5000
wrote:

In Excel 2007, I want to change the default format for comments, so that the
date the comment was added is included in the comment as well as the name of
the user who added the comment.

Reply With QuoteReply With Quote