LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 182
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Outlook Alias into an Excel 2003 macro fidgitthedigit Excel Discussion (Misc queries) 0 May 29th 06 02:24 PM
SQL query removes alias BusterC Excel Discussion (Misc queries) 1 February 8th 06 04:35 PM
Can you use alias' for 'groups' in pivot tables ? Alias in pivot table Excel Discussion (Misc queries) 5 August 6th 05 09:53 PM
'Alias' for file name..... billsc Excel Worksheet Functions 4 July 7th 05 02:18 AM
MS Query - Alias syntax David P Excel Worksheet Functions 3 February 16th 05 09:29 AM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"