Alias for =today()
Hello, Bernard!
You wrote on Thu, 11 Jan 2007 16:19:50 -0400:
BL How about Tools | AutoCorrect
BL It is case sensitive and leaving the cell using navigation
BL key will not trigger the change but ENTER and TAB will.
BL Remember - AutoCorrect applies to ALL MS Office apps not
BL just Excel best wishes
BL
Now that's a really interesting thing to know! Thanks again!
?? I have a column formated for simple date. I'd like to be
?? able to enter "T" in the cell and have it automatically
?? insert the current date, when leaving the cell.
?? Essentially replacing "T" with =today(). What would be the
?? most efficient way of going about this.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
|