Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default automatic insert date when clicking cel


Hi,
Does anybody know how to make that when clicking the cel, the date o
that day appears in the cel and stays there.

Thank

--
Steve wildemeersc
-----------------------------------------------------------------------
Steve wildemeersch's Profile: http://www.msusenet.com/member.php?userid=482
View this thread: http://www.msusenet.com/t-187102511

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default automatic insert date when clicking cel


select the cell and push <cntrl; for the date and <cntr<shift: fo
the time

you wouldn't really want, for this to happen each time you click onto
cell.

regards

Steve wildemeersch Wrote:
Hi,
Does anybody know how to make that when clicking the cel, the date of
that day appears in the cel and stays there.

Thanks


--
Steve wildemeersch
------------------------------------------------------------------------
Steve wildemeersch's Profile
http://www.msusenet.com/member.php?userid=4821
View this thread: http://www.msusenet.com/t-187102511


--
bill

-----------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...info&userid=82
View this thread: http://www.excelforum.com/showthread.php?threadid=40091

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default automatic insert date when clicking cel


Thanks Bill,

thats easy enough...;-)

Regards

Stev

--
Steve wildemeersc
-----------------------------------------------------------------------
Steve wildemeersch's Profile: http://www.msusenet.com/member.php?userid=482
View this thread: http://www.msusenet.com/t-187102511

Reply
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
if/then insert date but don't want automatic updates redleg Excel Discussion (Misc queries) 7 September 29th 09 09:59 PM
Clicking insert worksheet and it brings up template SGagne Excel Discussion (Misc queries) 1 January 16th 09 05:00 PM
Excel Automatic Date Insert CJ Excel Worksheet Functions 1 August 29th 08 05:35 PM
After clicking on fx how do I turn off the insert function window Brent_in_Oregon Excel Discussion (Misc queries) 1 January 3rd 07 06:45 PM
Insert Automatic, Non-Updating Date Stamp Ken Zenachon Excel Discussion (Misc queries) 8 January 18th 06 06:52 PM


All times are GMT +1. The time now is 05:07 AM.

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

About Us

"It's about Microsoft Excel"